Dataset statistics
| Number of variables | 42 |
|---|---|
| Number of observations | 46927 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 13.5 MiB |
| Average record size in memory | 301.0 B |
Variable types
| Numeric | 20 |
|---|---|
| DateTime | 1 |
| Text | 2 |
| Categorical | 14 |
| Boolean | 5 |
booking_datetime is highly overall correlated with checkin_date and 2 other fields | High correlation |
checkin_date is highly overall correlated with booking_datetime and 1 other fields | High correlation |
checkout_date is highly overall correlated with booking_datetime and 1 other fields | High correlation |
hotel_star_rating is highly overall correlated with price_per_guest_per_night | High correlation |
no_of_adults is highly overall correlated with no_of_room and 1 other fields | High correlation |
no_of_room is highly overall correlated with no_of_adults | High correlation |
origin_country_code is highly overall correlated with original_payment_currency | High correlation |
language is highly overall correlated with original_payment_currency | High correlation |
original_selling_amount is highly overall correlated with amount_nights and 1 other fields | High correlation |
distance_booking_checkin is highly overall correlated with booking_datetime | High correlation |
amount_guests is highly overall correlated with no_of_adults | High correlation |
amount_nights is highly overall correlated with original_selling_amount | High correlation |
price_per_guest_per_night is highly overall correlated with hotel_star_rating and 1 other fields | High correlation |
original_payment_currency is highly overall correlated with origin_country_code and 1 other fields | High correlation |
request_nonesmoke is highly overall correlated with has_request | High correlation |
request_highfloor is highly overall correlated with has_request | High correlation |
request_largebed is highly overall correlated with has_request | High correlation |
has_request is highly overall correlated with request_nonesmoke and 2 other fields | High correlation |
no_of_extra_bed is highly imbalanced (96.1%) | Imbalance |
original_payment_method is highly imbalanced (58.3%) | Imbalance |
original_payment_type is highly imbalanced (91.4%) | Imbalance |
request_latecheckin is highly imbalanced (88.8%) | Imbalance |
request_highfloor is highly imbalanced (57.6%) | Imbalance |
request_twinbeds is highly imbalanced (56.0%) | Imbalance |
request_airport is highly imbalanced (96.0%) | Imbalance |
request_earlycheckin is highly imbalanced (86.3%) | Imbalance |
original_selling_amount is highly skewed (γ1 = 36.55009602) | Skewed |
h_booking_id has unique values | Unique |
hotel_star_rating has 2060 (4.4%) zeros | Zeros |
accommadation_type_name has 938 (2.0%) zeros | Zeros |
no_of_children has 42690 (91.0%) zeros | Zeros |
Reproduction
| Analysis started | 2023-06-08 14:32:27.992204 |
|---|---|
| Analysis finished | 2023-06-08 14:33:38.842265 |
| Duration | 1 minute and 10.85 seconds |
| Software version | ydata-profiling vv4.2.0 |
| Download configuration | config.json |
h_booking_id
Real number (ℝ)
| Distinct | 46927 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -1.7482761 × 1016 |
| Minimum | -9.2231941 × 1018 |
|---|---|
| Maximum | 9.2233383 × 1018 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 23545 |
| Negative (%) | 50.2% |
| Memory size | 366.7 KiB |
Quantile statistics
| Minimum | -9.2231941 × 1018 |
|---|---|
| 5-th percentile | -8.3231332 × 1018 |
| Q1 | -4.6146133 × 1018 |
| median | -3.2064787 × 1016 |
| Q3 | 4.5760991 × 1018 |
| 95-th percentile | 8.2846133 × 1018 |
| Maximum | 9.2233383 × 1018 |
| Range | -2.1169456 × 1014 |
| Interquartile range (IQR) | 9.1907124 × 1018 |
Descriptive statistics
| Standard deviation | 5.3247643 × 1018 |
|---|---|
| Coefficient of variation (CV) | -304.57227 |
| Kurtosis | -1.1991323 |
| Mean | -1.7482761 × 1016 |
| Median Absolute Deviation (MAD) | 4.5955943 × 1018 |
| Skewness | 0.0033792406 |
| Sum | -8.756789 × 1018 |
| Variance | 2.8353114 × 1037 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 7.861445259 × 1018 | 1 | < 0.1% |
| -5.859385366 × 1018 | 1 | < 0.1% |
| 4.102580392 × 1018 | 1 | < 0.1% |
| 1.795941529 × 1018 | 1 | < 0.1% |
| -5.721949141 × 1018 | 1 | < 0.1% |
| -4.284526584 × 1018 | 1 | < 0.1% |
| 2.103613272 × 1018 | 1 | < 0.1% |
| 5.236811047 × 1018 | 1 | < 0.1% |
| -2.3832694 × 1018 | 1 | < 0.1% |
| -2.788888768 × 1018 | 1 | < 0.1% |
| Other values (46917) | 46917 |
| Value | Count | Frequency (%) |
| -9.223194056 × 1018 | 1 | |
| -9.222713784 × 1018 | 1 | |
| -9.222411208 × 1018 | 1 | |
| -9.222220846 × 1018 | 1 | |
| -9.220467519 × 1018 | 1 | |
| -9.219746746 × 1018 | 1 | |
| -9.219730436 × 1018 | 1 | |
| -9.219588531 × 1018 | 1 | |
| -9.219312947 × 1018 | 1 | |
| -9.219139934 × 1018 | 1 |
| Value | Count | Frequency (%) |
| 9.223338324 × 1018 | 1 | |
| 9.223221736 × 1018 | 1 | |
| 9.222651807 × 1018 | 1 | |
| 9.222015612 × 1018 | 1 | |
| 9.221958225 × 1018 | 1 | |
| 9.221798878 × 1018 | 1 | |
| 9.221611986 × 1018 | 1 | |
| 9.221457559 × 1018 | 1 | |
| 9.220807687 × 1018 | 1 | |
| 9.220787994 × 1018 | 1 |
booking_datetime
Real number (ℝ)
| Distinct | 357 |
|---|---|
| Distinct (%) | 0.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 199.2134 |
| Minimum | 1 |
|---|---|
| Maximum | 365 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 366.7 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 95 |
| Q1 | 180 |
| median | 206 |
| Q3 | 234 |
| 95-th percentile | 262 |
| Maximum | 365 |
| Range | 364 |
| Interquartile range (IQR) | 54 |
Descriptive statistics
| Standard deviation | 49.987481 |
|---|---|
| Coefficient of variation (CV) | 0.2509243 |
| Kurtosis | 1.8416776 |
| Mean | 199.2134 |
| Median Absolute Deviation (MAD) | 27 |
| Skewness | -1.0796464 |
| Sum | 9348487 |
| Variance | 2498.7483 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 183 | 541 | 1.2% |
| 184 | 526 | 1.1% |
| 186 | 505 | 1.1% |
| 205 | 505 | 1.1% |
| 199 | 500 | 1.1% |
| 185 | 497 | 1.1% |
| 213 | 491 | 1.0% |
| 187 | 491 | 1.0% |
| 193 | 490 | 1.0% |
| 197 | 488 | 1.0% |
| Other values (347) | 41893 |
| Value | Count | Frequency (%) |
| 1 | 8 | |
| 2 | 10 | |
| 3 | 9 | |
| 4 | 3 | < 0.1% |
| 5 | 9 | |
| 6 | 5 | < 0.1% |
| 7 | 10 | |
| 8 | 16 | |
| 9 | 17 | |
| 10 | 12 |
| Value | Count | Frequency (%) |
| 365 | 11 | |
| 364 | 3 | < 0.1% |
| 363 | 4 | < 0.1% |
| 362 | 5 | |
| 361 | 8 | |
| 360 | 5 | |
| 359 | 1 | < 0.1% |
| 358 | 3 | < 0.1% |
| 357 | 7 | |
| 356 | 2 | < 0.1% |
checkin_date
Real number (ℝ)
| Distinct | 105 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 226.65112 |
| Minimum | 158 |
|---|---|
| Maximum | 272 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 366.7 KiB |
Quantile statistics
| Minimum | 158 |
|---|---|
| 5-th percentile | 186 |
| Q1 | 205 |
| median | 226 |
| Q3 | 250 |
| 95-th percentile | 267 |
| Maximum | 272 |
| Range | 114 |
| Interquartile range (IQR) | 45 |
Descriptive statistics
| Standard deviation | 26.196808 |
|---|---|
| Coefficient of variation (CV) | 0.11558208 |
| Kurtosis | -1.1697685 |
| Mean | 226.65112 |
| Median Absolute Deviation (MAD) | 23 |
| Skewness | 0.0039606809 |
| Sum | 10636057 |
| Variance | 686.27273 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 209 | 864 | 1.8% |
| 258 | 801 | 1.7% |
| 208 | 784 | 1.7% |
| 230 | 784 | 1.7% |
| 265 | 771 | 1.6% |
| 251 | 748 | 1.6% |
| 188 | 705 | 1.5% |
| 223 | 691 | 1.5% |
| 216 | 669 | 1.4% |
| 195 | 666 | 1.4% |
| Other values (95) | 39444 |
| Value | Count | Frequency (%) |
| 158 | 1 | < 0.1% |
| 166 | 1 | < 0.1% |
| 167 | 1 | < 0.1% |
| 168 | 1 | < 0.1% |
| 172 | 5 | < 0.1% |
| 173 | 3 | < 0.1% |
| 174 | 7 | |
| 175 | 13 | |
| 176 | 14 | |
| 177 | 15 |
| Value | Count | Frequency (%) |
| 272 | 482 | |
| 271 | 515 | |
| 270 | 406 | |
| 269 | 419 | |
| 268 | 427 | |
| 267 | 436 | |
| 266 | 547 | |
| 265 | 771 | |
| 264 | 647 | |
| 263 | 495 |
checkout_date
Real number (ℝ)
| Distinct | 91 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 228.64479 |
| Minimum | 183 |
|---|---|
| Maximum | 273 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 366.7 KiB |
Quantile statistics
| Minimum | 183 |
|---|---|
| 5-th percentile | 188 |
| Q1 | 207 |
| median | 229 |
| Q3 | 252 |
| 95-th percentile | 269 |
| Maximum | 273 |
| Range | 90 |
| Interquartile range (IQR) | 45 |
Descriptive statistics
| Standard deviation | 26.114705 |
|---|---|
| Coefficient of variation (CV) | 0.11421518 |
| Kurtosis | -1.1822042 |
| Mean | 228.64479 |
| Median Absolute Deviation (MAD) | 23 |
| Skewness | 0.0061513478 |
| Sum | 10729614 |
| Variance | 681.97779 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 210 | 999 | 2.1% |
| 231 | 868 | 1.8% |
| 259 | 843 | 1.8% |
| 273 | 792 | 1.7% |
| 189 | 784 | 1.7% |
| 196 | 781 | 1.7% |
| 266 | 774 | 1.6% |
| 217 | 773 | 1.6% |
| 252 | 763 | 1.6% |
| 238 | 732 | 1.6% |
| Other values (81) | 38818 |
| Value | Count | Frequency (%) |
| 183 | 504 | |
| 184 | 409 | |
| 185 | 413 | |
| 186 | 403 | |
| 187 | 424 | |
| 188 | 484 | |
| 189 | 784 | |
| 190 | 423 | |
| 191 | 402 | |
| 192 | 383 |
| Value | Count | Frequency (%) |
| 273 | 792 | |
| 272 | 554 | |
| 271 | 444 | |
| 270 | 457 | |
| 269 | 454 | |
| 268 | 466 | |
| 267 | 661 | |
| 266 | 774 | |
| 265 | 552 | |
| 264 | 420 |
hotel_id
Real number (ℝ)
| Distinct | 24969 |
|---|---|
| Distinct (%) | 53.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1341712.9 |
| Minimum | 1 |
|---|---|
| Maximum | 5823993 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 366.7 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 10917.6 |
| Q1 | 255829 |
| median | 798535 |
| Q3 | 2284662 |
| 95-th percentile | 4168202 |
| Maximum | 5823993 |
| Range | 5823992 |
| Interquartile range (IQR) | 2028833 |
Descriptive statistics
| Standard deviation | 1361519.7 |
|---|---|
| Coefficient of variation (CV) | 1.0147624 |
| Kurtosis | 0.077266214 |
| Mean | 1341712.9 |
| Median Absolute Deviation (MAD) | 675419 |
| Skewness | 1.0483226 |
| Sum | 6.296256 × 1010 |
| Variance | 1.853736 × 1012 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 6452 | 273 | 0.6% |
| 461790 | 54 | 0.1% |
| 304294 | 46 | 0.1% |
| 3080111 | 42 | 0.1% |
| 337607 | 36 | 0.1% |
| 185945 | 34 | 0.1% |
| 1603143 | 34 | 0.1% |
| 43450 | 33 | 0.1% |
| 4426497 | 32 | 0.1% |
| 1270365 | 32 | 0.1% |
| Other values (24959) | 46311 |
| Value | Count | Frequency (%) |
| 1 | 2 | |
| 16 | 2 | |
| 75 | 2 | |
| 85 | 1 | < 0.1% |
| 99 | 3 | |
| 122 | 2 | |
| 140 | 1 | < 0.1% |
| 148 | 1 | < 0.1% |
| 153 | 1 | < 0.1% |
| 168 | 4 |
| Value | Count | Frequency (%) |
| 5823993 | 1 | |
| 5808200 | 1 | |
| 5799579 | 1 | |
| 5798032 | 1 | |
| 5797970 | 1 | |
| 5795465 | 1 | |
| 5790845 | 1 | |
| 5785518 | 1 | |
| 5771209 | 1 | |
| 5761104 | 1 |
hotel_country_code
Real number (ℝ)
| Distinct | 126 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 76.486756 |
| Minimum | 0 |
|---|---|
| Maximum | 125 |
| Zeros | 380 |
| Zeros (%) | 0.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 366.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 24 |
| Q1 | 57 |
| median | 80 |
| Q3 | 109 |
| 95-th percentile | 118 |
| Maximum | 125 |
| Range | 125 |
| Interquartile range (IQR) | 52 |
Descriptive statistics
| Standard deviation | 31.100448 |
|---|---|
| Coefficient of variation (CV) | 0.4066122 |
| Kurtosis | -0.83994882 |
| Mean | 76.486756 |
| Median Absolute Deviation (MAD) | 29 |
| Skewness | -0.24798175 |
| Sum | 3589294 |
| Variance | 967.2379 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 57 | 7357 | |
| 109 | 6331 | |
| 80 | 6136 | |
| 114 | 4062 | 8.7% |
| 49 | 2883 | 6.1% |
| 61 | 2718 | 5.8% |
| 92 | 2128 | 4.5% |
| 121 | 2105 | 4.5% |
| 118 | 1445 | 3.1% |
| 45 | 1295 | 2.8% |
| Other values (116) | 10467 |
| Value | Count | Frequency (%) |
| 0 | 380 | |
| 1 | 2 | < 0.1% |
| 2 | 4 | < 0.1% |
| 3 | 10 | < 0.1% |
| 4 | 114 | 0.2% |
| 5 | 835 | |
| 6 | 1 | < 0.1% |
| 7 | 6 | < 0.1% |
| 8 | 3 | < 0.1% |
| 9 | 5 | < 0.1% |
| Value | Count | Frequency (%) |
| 125 | 4 | < 0.1% |
| 124 | 3 | < 0.1% |
| 123 | 115 | 0.2% |
| 122 | 2 | < 0.1% |
| 121 | 2105 | |
| 120 | 4 | < 0.1% |
| 119 | 1 | < 0.1% |
| 118 | 1445 | |
| 117 | 1 | < 0.1% |
| 116 | 18 | < 0.1% |
hotel_live_date
Date
| Distinct | 17476 |
|---|---|
| Distinct (%) | 37.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 366.7 KiB |
| Minimum | 1999-09-09 00:00:00 |
|---|---|
| Maximum | 2019-04-18 10:17:00 |
hotel_star_rating
Real number (ℝ)
HIGH CORRELATION  ZEROS 
| Distinct | 11 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.2239968 |
| Minimum | -1 |
|---|---|
| Maximum | 5 |
| Zeros | 2060 |
| Zeros (%) | 4.4% |
| Negative | 1 |
| Negative (%) | < 0.1% |
| Memory size | 366.7 KiB |
Quantile statistics
| Minimum | -1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3 |
| median | 3 |
| Q3 | 4 |
| 95-th percentile | 5 |
| Maximum | 5 |
| Range | 6 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 1.1722628 |
|---|---|
| Coefficient of variation (CV) | 0.36360543 |
| Kurtosis | 0.72713638 |
| Mean | 3.2239968 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | -0.79401111 |
| Sum | 151292.5 |
| Variance | 1.3742 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 3 | 14061 | |
| 4 | 12531 | |
| 5 | 5053 | 10.8% |
| 2 | 5018 | 10.7% |
| 3.5 | 3389 | 7.2% |
| 0 | 2060 | 4.4% |
| 2.5 | 1752 | 3.7% |
| 1 | 1342 | 2.9% |
| 4.5 | 1174 | 2.5% |
| 1.5 | 546 | 1.2% |
| Value | Count | Frequency (%) |
| -1 | 1 | < 0.1% |
| 0 | 2060 | 4.4% |
| 1 | 1342 | 2.9% |
| 1.5 | 546 | 1.2% |
| 2 | 5018 | 10.7% |
| 2.5 | 1752 | 3.7% |
| 3 | 14061 | |
| 3.5 | 3389 | 7.2% |
| 4 | 12531 | |
| 4.5 | 1174 | 2.5% |
| Value | Count | Frequency (%) |
| 5 | 5053 | 10.8% |
| 4.5 | 1174 | 2.5% |
| 4 | 12531 | |
| 3.5 | 3389 | 7.2% |
| 3 | 14061 | |
| 2.5 | 1752 | 3.7% |
| 2 | 5018 | 10.7% |
| 1.5 | 546 | 1.2% |
| 1 | 1342 | 2.9% |
| 0 | 2060 | 4.4% |
accommadation_type_name
Real number (ℝ)
| Distinct | 22 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 10.395785 |
| Minimum | 0 |
|---|---|
| Maximum | 21 |
| Zeros | 938 |
| Zeros (%) | 2.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 366.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 5 |
| Q1 | 10 |
| median | 10 |
| Q3 | 10 |
| 95-th percentile | 16 |
| Maximum | 21 |
| Range | 21 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 3.1764249 |
|---|---|
| Coefficient of variation (CV) | 0.30554931 |
| Kurtosis | 2.770737 |
| Mean | 10.395785 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 0.1664497 |
| Sum | 487843 |
| Variance | 10.089675 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 10 | 34255 | |
| 16 | 4553 | 9.7% |
| 5 | 2319 | 4.9% |
| 9 | 2075 | 4.4% |
| 19 | 1180 | 2.5% |
| 0 | 938 | 2.0% |
| 14 | 454 | 1.0% |
| 17 | 278 | 0.6% |
| 3 | 270 | 0.6% |
| 18 | 238 | 0.5% |
| Other values (12) | 367 | 0.8% |
| Value | Count | Frequency (%) |
| 0 | 938 | |
| 1 | 5 | < 0.1% |
| 2 | 93 | 0.2% |
| 3 | 270 | 0.6% |
| 4 | 1 | < 0.1% |
| 5 | 2319 | |
| 6 | 37 | 0.1% |
| 7 | 88 | 0.2% |
| 8 | 1 | < 0.1% |
| 9 | 2075 |
| Value | Count | Frequency (%) |
| 21 | 65 | 0.1% |
| 20 | 11 | < 0.1% |
| 19 | 1180 | 2.5% |
| 18 | 238 | 0.5% |
| 17 | 278 | 0.6% |
| 16 | 4553 | |
| 15 | 52 | 0.1% |
| 14 | 454 | 1.0% |
| 13 | 8 | < 0.1% |
| 12 | 3 | < 0.1% |
| Distinct | 136 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 366.7 KiB |
Length
| Max length | 32 |
|---|---|
| Median length | 21 |
| Mean length | 8.8196134 |
| Min length | 4 |
Characters and Unicode
| Total characters | 413878 |
|---|---|
| Distinct characters | 55 |
| Distinct categories | 5 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 2 ? |
Unique
| Unique | 27 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | China |
|---|---|
| 2nd row | Japan |
| 3rd row | Taiwan |
| 4th row | Turkey |
| 5th row | South Korea |
| Value | Count | Frequency (%) |
| south | 6364 | 10.0% |
| korea | 6227 | 9.8% |
| malaysia | 6068 | 9.5% |
| taiwan | 5059 | 8.0% |
| thailand | 3409 | 5.4% |
| united | 3078 | 4.8% |
| china | 2669 | 4.2% |
| japan | 2330 | 3.7% |
| hong | 2241 | 3.5% |
| kong | 2241 | 3.5% |
| Other values (151) | 23912 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 68559 | |
| i | 37749 | 9.1% |
| n | 33947 | 8.2% |
| o | 24183 | 5.8% |
| e | 22684 | 5.5% |
| t | 16690 | 4.0% |
| 16667 | 4.0% | |
| r | 14661 | 3.5% |
| s | 14628 | 3.5% |
| h | 14514 | 3.5% |
| Other values (45) | 149596 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 322079 | |
| Uppercase Letter | 75123 | 18.2% |
| Space Separator | 16671 | 4.0% |
| Dash Punctuation | 3 | < 0.1% |
| Other Punctuation | 2 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 68559 | |
| i | 37749 | |
| n | 33947 | |
| o | 24183 | 7.5% |
| e | 22684 | 7.0% |
| t | 16690 | 5.2% |
| r | 14661 | 4.6% |
| s | 14628 | 4.5% |
| h | 14514 | 4.5% |
| l | 14009 | 4.3% |
| Other values (16) | 60455 |
Uppercase Letter
| Value | Count | Frequency (%) |
| K | 11677 | |
| S | 11036 | |
| T | 8579 | |
| N | 7190 | |
| M | 6499 | |
| U | 5347 | |
| A | 4143 | 5.5% |
| C | 3152 | 4.2% |
| I | 3066 | 4.1% |
| O | 2363 | 3.1% |
| Other values (15) | 12071 |
Space Separator
| Value | Count | Frequency (%) |
| 16667 | ||
| Â | 4 | < 0.1% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 3 |
Other Punctuation
| Value | Count | Frequency (%) |
| ' | 2 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 397202 | |
| Common | 16676 | 4.0% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 68559 | |
| i | 37749 | 9.5% |
| n | 33947 | 8.5% |
| o | 24183 | 6.1% |
| e | 22684 | 5.7% |
| t | 16690 | 4.2% |
| r | 14661 | 3.7% |
| s | 14628 | 3.7% |
| h | 14514 | 3.7% |
| l | 14009 | 3.5% |
| Other values (41) | 135578 |
Common
| Value | Count | Frequency (%) |
| 16667 | ||
| Â | 4 | < 0.1% |
| - | 3 | < 0.1% |
| ' | 2 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 413874 | |
| None | 4 | < 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 68559 | |
| i | 37749 | 9.1% |
| n | 33947 | 8.2% |
| o | 24183 | 5.8% |
| e | 22684 | 5.5% |
| t | 16690 | 4.0% |
| 16667 | 4.0% | |
| r | 14661 | 3.5% |
| s | 14628 | 3.5% |
| h | 14514 | 3.5% |
| Other values (44) | 149592 |
None
| Value | Count | Frequency (%) |
| Â | 4 |
guest_is_not_the_customer
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 366.7 KiB |
| 0 | |
|---|---|
| 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 46927 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 36872 | |
| 1 | 10055 | 21.4% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 36872 | |
| 1 | 10055 | 21.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 36872 | |
| 1 | 10055 | 21.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 46927 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 36872 | |
| 1 | 10055 | 21.4% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 46927 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 36872 | |
| 1 | 10055 | 21.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 46927 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 36872 | |
| 1 | 10055 | 21.4% |
| Distinct | 144 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 366.7 KiB |
Length
| Max length | 32 |
|---|---|
| Median length | 26 |
| Mean length | 8.4160718 |
| Min length | 4 |
Characters and Unicode
| Total characters | 394941 |
|---|---|
| Distinct characters | 57 |
| Distinct categories | 6 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 2 ? |
Unique
| Unique | 34 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | China |
|---|---|
| 2nd row | Japan |
| 3rd row | Taiwan |
| 4th row | Turkey |
| 5th row | South Korea |
| Value | Count | Frequency (%) |
| south | 6765 | 11.2% |
| korea | 6634 | 11.0% |
| malaysia | 6163 | 10.2% |
| taiwan | 5347 | 8.9% |
| thailand | 3514 | 5.8% |
| united | 3211 | 5.3% |
| china | 3075 | 5.1% |
| japan | 2469 | 4.1% |
| hong | 2287 | 3.8% |
| kong | 2287 | 3.8% |
| Other values (162) | 18660 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 69572 | |
| i | 37621 | 9.5% |
| n | 35710 | 9.0% |
| o | 23356 | 5.9% |
| e | 21766 | 5.5% |
| t | 17532 | 4.4% |
| h | 15545 | 3.9% |
| s | 15086 | 3.8% |
| l | 14393 | 3.6% |
| 13481 | 3.4% | |
| Other values (47) | 130879 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 321012 | |
| Uppercase Letter | 60439 | 15.3% |
| Space Separator | 13485 | 3.4% |
| Other Punctuation | 3 | < 0.1% |
| Open Punctuation | 1 | < 0.1% |
| Close Punctuation | 1 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 69572 | |
| i | 37621 | |
| n | 35710 | |
| o | 23356 | 7.3% |
| e | 21766 | 6.8% |
| t | 17532 | 5.5% |
| h | 15545 | 4.8% |
| s | 15086 | 4.7% |
| l | 14393 | 4.5% |
| r | 13380 | 4.2% |
| Other values (16) | 57051 |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 11588 | |
| K | 9947 | |
| T | 8986 | |
| M | 6640 | |
| C | 3587 | 5.9% |
| U | 3249 | 5.4% |
| I | 3217 | 5.3% |
| J | 2481 | 4.1% |
| H | 2298 | 3.8% |
| A | 2284 | 3.8% |
| Other values (15) | 6162 |
Space Separator
| Value | Count | Frequency (%) |
| 13481 | ||
| Â | 4 | < 0.1% |
Other Punctuation
| Value | Count | Frequency (%) |
| ' | 2 | |
| & | 1 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 1 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 1 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 381451 | |
| Common | 13490 | 3.4% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 69572 | |
| i | 37621 | 9.9% |
| n | 35710 | 9.4% |
| o | 23356 | 6.1% |
| e | 21766 | 5.7% |
| t | 17532 | 4.6% |
| h | 15545 | 4.1% |
| s | 15086 | 4.0% |
| l | 14393 | 3.8% |
| r | 13380 | 3.5% |
| Other values (41) | 117490 |
Common
| Value | Count | Frequency (%) |
| 13481 | ||
| Â | 4 | < 0.1% |
| ' | 2 | < 0.1% |
| & | 1 | < 0.1% |
| ( | 1 | < 0.1% |
| ) | 1 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 394937 | |
| None | 4 | < 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 69572 | |
| i | 37621 | 9.5% |
| n | 35710 | 9.0% |
| o | 23356 | 5.9% |
| e | 21766 | 5.5% |
| t | 17532 | 4.4% |
| h | 15545 | 3.9% |
| s | 15086 | 3.8% |
| l | 14393 | 3.6% |
| 13481 | 3.4% | |
| Other values (46) | 130875 |
None
| Value | Count | Frequency (%) |
| Â | 4 |
no_of_adults
Real number (ℝ)
| Distinct | 21 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.3475611 |
| Minimum | 1 |
|---|---|
| Maximum | 30 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 366.7 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 2 |
| Q3 | 2 |
| 95-th percentile | 4 |
| Maximum | 30 |
| Range | 29 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 1.3241378 |
|---|---|
| Coefficient of variation (CV) | 0.56404829 |
| Kurtosis | 33.488263 |
| Mean | 2.3475611 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 4.2137414 |
| Sum | 110164 |
| Variance | 1.753341 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2 | 32070 | |
| 1 | 5481 | 11.7% |
| 4 | 4492 | 9.6% |
| 3 | 2905 | 6.2% |
| 6 | 926 | 2.0% |
| 5 | 378 | 0.8% |
| 8 | 301 | 0.6% |
| 10 | 101 | 0.2% |
| 7 | 81 | 0.2% |
| 12 | 67 | 0.1% |
| Other values (11) | 125 | 0.3% |
| Value | Count | Frequency (%) |
| 1 | 5481 | 11.7% |
| 2 | 32070 | |
| 3 | 2905 | 6.2% |
| 4 | 4492 | 9.6% |
| 5 | 378 | 0.8% |
| 6 | 926 | 2.0% |
| 7 | 81 | 0.2% |
| 8 | 301 | 0.6% |
| 9 | 49 | 0.1% |
| 10 | 101 | 0.2% |
| Value | Count | Frequency (%) |
| 30 | 1 | < 0.1% |
| 27 | 2 | < 0.1% |
| 20 | 1 | < 0.1% |
| 18 | 18 | < 0.1% |
| 17 | 2 | < 0.1% |
| 16 | 16 | < 0.1% |
| 15 | 4 | < 0.1% |
| 14 | 16 | < 0.1% |
| 13 | 3 | < 0.1% |
| 12 | 67 |
no_of_children
Real number (ℝ)
| Distinct | 10 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.14814499 |
| Minimum | 0 |
|---|---|
| Maximum | 10 |
| Zeros | 42690 |
| Zeros (%) | 91.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 366.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 10 |
| Range | 10 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.52912642 |
|---|---|
| Coefficient of variation (CV) | 3.5716795 |
| Kurtosis | 25.197554 |
| Mean | 0.14814499 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 4.4201626 |
| Sum | 6952 |
| Variance | 0.27997477 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 42690 | |
| 1 | 2117 | 4.5% |
| 2 | 1726 | 3.7% |
| 3 | 251 | 0.5% |
| 4 | 109 | 0.2% |
| 5 | 18 | < 0.1% |
| 6 | 12 | < 0.1% |
| 7 | 2 | < 0.1% |
| 10 | 1 | < 0.1% |
| 8 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 42690 | |
| 1 | 2117 | 4.5% |
| 2 | 1726 | 3.7% |
| 3 | 251 | 0.5% |
| 4 | 109 | 0.2% |
| 5 | 18 | < 0.1% |
| 6 | 12 | < 0.1% |
| 7 | 2 | < 0.1% |
| 8 | 1 | < 0.1% |
| 10 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 10 | 1 | < 0.1% |
| 8 | 1 | < 0.1% |
| 7 | 2 | < 0.1% |
| 6 | 12 | < 0.1% |
| 5 | 18 | < 0.1% |
| 4 | 109 | 0.2% |
| 3 | 251 | 0.5% |
| 2 | 1726 | 3.7% |
| 1 | 2117 | 4.5% |
| 0 | 42690 |
no_of_extra_bed
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 366.7 KiB |
| 0 | |
|---|---|
| 1 | 483 |
| 2 | 22 |
| 3 | 5 |
| 5 | 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 46927 |
|---|---|
| Distinct characters | 5 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 46416 | |
| 1 | 483 | 1.0% |
| 2 | 22 | < 0.1% |
| 3 | 5 | < 0.1% |
| 5 | 1 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 46416 | |
| 1 | 483 | 1.0% |
| 2 | 22 | < 0.1% |
| 3 | 5 | < 0.1% |
| 5 | 1 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 46416 | |
| 1 | 483 | 1.0% |
| 2 | 22 | < 0.1% |
| 3 | 5 | < 0.1% |
| 5 | 1 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 46927 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 46416 | |
| 1 | 483 | 1.0% |
| 2 | 22 | < 0.1% |
| 3 | 5 | < 0.1% |
| 5 | 1 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 46927 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 46416 | |
| 1 | 483 | 1.0% |
| 2 | 22 | < 0.1% |
| 3 | 5 | < 0.1% |
| 5 | 1 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 46927 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 46416 | |
| 1 | 483 | 1.0% |
| 2 | 22 | < 0.1% |
| 3 | 5 | < 0.1% |
| 5 | 1 | < 0.1% |
no_of_room
Real number (ℝ)
| Distinct | 9 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.140303 |
| Minimum | 1 |
|---|---|
| Maximum | 9 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 366.7 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 2 |
| Maximum | 9 |
| Range | 8 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.51904538 |
|---|---|
| Coefficient of variation (CV) | 0.45518197 |
| Kurtosis | 52.885359 |
| Mean | 1.140303 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 5.9691302 |
| Sum | 53511 |
| Variance | 0.26940811 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 42320 | |
| 2 | 3426 | 7.3% |
| 3 | 751 | 1.6% |
| 4 | 244 | 0.5% |
| 5 | 106 | 0.2% |
| 6 | 32 | 0.1% |
| 9 | 20 | < 0.1% |
| 7 | 16 | < 0.1% |
| 8 | 12 | < 0.1% |
| Value | Count | Frequency (%) |
| 1 | 42320 | |
| 2 | 3426 | 7.3% |
| 3 | 751 | 1.6% |
| 4 | 244 | 0.5% |
| 5 | 106 | 0.2% |
| 6 | 32 | 0.1% |
| 7 | 16 | < 0.1% |
| 8 | 12 | < 0.1% |
| 9 | 20 | < 0.1% |
| Value | Count | Frequency (%) |
| 9 | 20 | < 0.1% |
| 8 | 12 | < 0.1% |
| 7 | 16 | < 0.1% |
| 6 | 32 | 0.1% |
| 5 | 106 | 0.2% |
| 4 | 244 | 0.5% |
| 3 | 751 | 1.6% |
| 2 | 3426 | 7.3% |
| 1 | 42320 |
origin_country_code
Real number (ℝ)
| Distinct | 142 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 88.098493 |
| Minimum | 0 |
|---|---|
| Maximum | 141 |
| Zeros | 66 |
| Zeros (%) | 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 366.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 31 |
| Q1 | 62 |
| median | 94 |
| Q3 | 125 |
| 95-th percentile | 134 |
| Maximum | 141 |
| Range | 141 |
| Interquartile range (IQR) | 63 |
Descriptive statistics
| Standard deviation | 35.574492 |
|---|---|
| Coefficient of variation (CV) | 0.40380364 |
| Kurtosis | -0.78049251 |
| Mean | 88.098493 |
| Median Absolute Deviation (MAD) | 31 |
| Skewness | -0.37769 |
| Sum | 4134198 |
| Variance | 1265.5445 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 74 | 6298 | |
| 94 | 6185 | |
| 130 | 5255 | |
| 125 | 4308 | 9.2% |
| 70 | 2530 | 5.4% |
| 31 | 2494 | 5.3% |
| 55 | 2424 | 5.2% |
| 58 | 2263 | 4.8% |
| 134 | 1960 | 4.2% |
| 119 | 1926 | 4.1% |
| Other values (132) | 11284 |
| Value | Count | Frequency (%) |
| 0 | 66 | 0.1% |
| 1 | 1 | < 0.1% |
| 2 | 325 | 0.7% |
| 3 | 2 | < 0.1% |
| 4 | 2 | < 0.1% |
| 5 | 3 | < 0.1% |
| 6 | 13 | < 0.1% |
| 7 | 22 | < 0.1% |
| 8 | 60 | 0.1% |
| 9 | 1069 |
| Value | Count | Frequency (%) |
| 141 | 2 | < 0.1% |
| 140 | 2 | < 0.1% |
| 139 | 2 | < 0.1% |
| 138 | 131 | 0.3% |
| 137 | 1362 | |
| 136 | 1 | < 0.1% |
| 135 | 5 | < 0.1% |
| 134 | 1960 | |
| 133 | 4 | < 0.1% |
| 132 | 24 | 0.1% |
language
Real number (ℝ)
| Distinct | 49 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 23.379462 |
| Minimum | 0 |
|---|---|
| Maximum | 48 |
| Zeros | 466 |
| Zeros (%) | 1.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 366.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 8 |
| Q1 | 8 |
| median | 26 |
| Q3 | 37 |
| 95-th percentile | 45 |
| Maximum | 48 |
| Range | 48 |
| Interquartile range (IQR) | 29 |
Descriptive statistics
| Standard deviation | 14.699654 |
|---|---|
| Coefficient of variation (CV) | 0.62874219 |
| Kurtosis | -1.4965756 |
| Mean | 23.379462 |
| Median Absolute Deviation (MAD) | 17 |
| Skewness | 0.21910009 |
| Sum | 1097128 |
| Variance | 216.07983 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 8 | 17238 | |
| 27 | 6684 | 14.2% |
| 43 | 5776 | 12.3% |
| 37 | 3217 | 6.9% |
| 26 | 2436 | 5.2% |
| 45 | 2399 | 5.1% |
| 44 | 1929 | 4.1% |
| 16 | 1293 | 2.8% |
| 24 | 765 | 1.6% |
| 48 | 636 | 1.4% |
| Other values (39) | 4554 | 9.7% |
| Value | Count | Frequency (%) |
| 0 | 466 | 1.0% |
| 1 | 2 | < 0.1% |
| 2 | 13 | < 0.1% |
| 3 | 1 | < 0.1% |
| 4 | 17 | < 0.1% |
| 5 | 63 | 0.1% |
| 6 | 148 | 0.3% |
| 7 | 5 | < 0.1% |
| 8 | 17238 | |
| 9 | 480 | 1.0% |
| Value | Count | Frequency (%) |
| 48 | 636 | 1.4% |
| 47 | 4 | < 0.1% |
| 46 | 65 | 0.1% |
| 45 | 2399 | |
| 44 | 1929 | 4.1% |
| 43 | 5776 | |
| 42 | 90 | 0.2% |
| 41 | 6 | < 0.1% |
| 40 | 9 | < 0.1% |
| 39 | 229 | 0.5% |
original_selling_amount
Real number (ℝ)
HIGH CORRELATION  SKEWED 
| Distinct | 26481 |
|---|---|
| Distinct (%) | 56.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 219.59182 |
| Minimum | 2.1 |
|---|---|
| Maximum | 49566.16 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 366.7 KiB |
Quantile statistics
| Minimum | 2.1 |
|---|---|
| 5-th percentile | 17.7 |
| Q1 | 50.585 |
| median | 107.78 |
| Q3 | 243.01 |
| 95-th percentile | 750.268 |
| Maximum | 49566.16 |
| Range | 49564.06 |
| Interquartile range (IQR) | 192.425 |
Descriptive statistics
| Standard deviation | 439.9447 |
|---|---|
| Coefficient of variation (CV) | 2.0034658 |
| Kurtosis | 3515.9943 |
| Mean | 219.59182 |
| Median Absolute Deviation (MAD) | 72.27 |
| Skewness | 36.550096 |
| Sum | 10304785 |
| Variance | 193551.34 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 122.63 | 14 | < 0.1% |
| 15 | 12 | < 0.1% |
| 37.05 | 12 | < 0.1% |
| 22 | 11 | < 0.1% |
| 45 | 11 | < 0.1% |
| 19.56 | 11 | < 0.1% |
| 222.94 | 10 | < 0.1% |
| 28.46 | 10 | < 0.1% |
| 30 | 10 | < 0.1% |
| 16.86 | 10 | < 0.1% |
| Other values (26471) | 46816 |
| Value | Count | Frequency (%) |
| 2.1 | 1 | |
| 2.27 | 1 | |
| 2.31 | 1 | |
| 2.5 | 1 | |
| 2.59 | 1 | |
| 2.64 | 1 | |
| 2.76 | 1 | |
| 2.8 | 1 | |
| 2.82 | 1 | |
| 2.9 | 1 |
| Value | Count | Frequency (%) |
| 49566.16 | 1 | |
| 17942.82 | 1 | |
| 15430.5 | 1 | |
| 13015.52 | 1 | |
| 11672.15 | 1 | |
| 9562.86 | 1 | |
| 9074.52 | 1 | |
| 9065.76 | 1 | |
| 8024.56 | 1 | |
| 7437.78 | 1 |
original_payment_method
Categorical
| Distinct | 36 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 366.7 KiB |
| Visa | |
|---|---|
| MasterCard | |
| UNKNOWN | |
| American Express | 2198 |
| JCB | 1124 |
| Other values (31) |
Length
| Max length | 21 |
|---|---|
| Median length | 20 |
| Mean length | 6.8831163 |
| Min length | 3 |
Characters and Unicode
| Total characters | 323004 |
|---|---|
| Distinct characters | 49 |
| Distinct categories | 5 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Alipay |
|---|---|
| 2nd row | American Express |
| 3rd row | Visa |
| 4th row | MasterCard |
| 5th row | Visa |
Common Values
| Value | Count | Frequency (%) |
| Visa | 23088 | |
| MasterCard | 13875 | |
| UNKNOWN | 3210 | 6.8% |
| American Express | 2198 | 4.7% |
| JCB | 1124 | 2.4% |
| Alipay | 945 | 2.0% |
| PayPal | 557 | 1.2% |
| MayBank2U | 430 | 0.9% |
| UnionPay - Creditcard | 292 | 0.6% |
| K PLUS | 206 | 0.4% |
| Other values (26) | 1002 | 2.1% |
Length
| Value | Count | Frequency (%) |
| visa | 23088 | |
| mastercard | 13875 | |
| unknown | 3210 | 6.3% |
| american | 2198 | 4.3% |
| express | 2198 | 4.3% |
| jcb | 1124 | 2.2% |
| alipay | 945 | 1.9% |
| paypal | 557 | 1.1% |
| maybank2u | 430 | 0.8% |
| unionpay | 339 | 0.7% |
| Other values (43) | 2784 | 5.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 57861 | |
| s | 41874 | |
| r | 32986 | |
| i | 27345 | |
| V | 23088 | 7.1% |
| e | 19220 | 6.0% |
| C | 15988 | 4.9% |
| M | 14788 | 4.6% |
| t | 14581 | 4.5% |
| d | 14574 | 4.5% |
| Other values (39) | 60699 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 228931 | |
| Uppercase Letter | 89464 | 27.7% |
| Space Separator | 3821 | 1.2% |
| Decimal Number | 449 | 0.1% |
| Dash Punctuation | 339 | 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 57861 | |
| s | 41874 | |
| r | 32986 | |
| i | 27345 | |
| e | 19220 | 8.4% |
| t | 14581 | 6.4% |
| d | 14574 | 6.4% |
| n | 3570 | 1.6% |
| p | 3303 | 1.4% |
| c | 2737 | 1.2% |
| Other values (13) | 10880 | 4.8% |
Uppercase Letter
| Value | Count | Frequency (%) |
| V | 23088 | |
| C | 15988 | |
| M | 14788 | |
| N | 9652 | |
| U | 4185 | 4.7% |
| K | 3449 | 3.9% |
| W | 3411 | 3.8% |
| A | 3382 | 3.8% |
| O | 3222 | 3.6% |
| E | 2248 | 2.5% |
| Other values (12) | 6051 | 6.8% |
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 430 | |
| 7 | 19 | 4.2% |
Space Separator
| Value | Count | Frequency (%) |
| 3821 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 339 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 318395 | |
| Common | 4609 | 1.4% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 57861 | |
| s | 41874 | |
| r | 32986 | |
| i | 27345 | |
| V | 23088 | 7.3% |
| e | 19220 | 6.0% |
| C | 15988 | 5.0% |
| M | 14788 | 4.6% |
| t | 14581 | 4.6% |
| d | 14574 | 4.6% |
| Other values (35) | 56090 |
Common
| Value | Count | Frequency (%) |
| 3821 | ||
| 2 | 430 | 9.3% |
| - | 339 | 7.4% |
| 7 | 19 | 0.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 323004 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 57861 | |
| s | 41874 | |
| r | 32986 | |
| i | 27345 | |
| V | 23088 | 7.1% |
| e | 19220 | 6.0% |
| C | 15988 | 4.9% |
| M | 14788 | 4.6% |
| t | 14581 | 4.5% |
| d | 14574 | 4.5% |
| Other values (39) | 60699 |
original_payment_type
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 366.7 KiB |
| Credit Card | |
|---|---|
| Invoice | 612 |
| Gift Card | 183 |
Length
| Max length | 11 |
|---|---|
| Median length | 11 |
| Mean length | 10.940035 |
| Min length | 7 |
Characters and Unicode
| Total characters | 513383 |
|---|---|
| Distinct characters | 15 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Credit Card |
|---|---|
| 2nd row | Credit Card |
| 3rd row | Credit Card |
| 4th row | Credit Card |
| 5th row | Credit Card |
Common Values
| Value | Count | Frequency (%) |
| Credit Card | 46132 | |
| Invoice | 612 | 1.3% |
| Gift Card | 183 | 0.4% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| card | 46315 | |
| credit | 46132 | |
| invoice | 612 | 0.7% |
| gift | 183 | 0.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| C | 92447 | |
| r | 92447 | |
| d | 92447 | |
| i | 46927 | |
| e | 46744 | |
| t | 46315 | |
| 46315 | ||
| a | 46315 | |
| I | 612 | 0.1% |
| n | 612 | 0.1% |
| Other values (5) | 2202 | 0.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 373826 | |
| Uppercase Letter | 93242 | 18.2% |
| Space Separator | 46315 | 9.0% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| r | 92447 | |
| d | 92447 | |
| i | 46927 | |
| e | 46744 | |
| t | 46315 | |
| a | 46315 | |
| n | 612 | 0.2% |
| v | 612 | 0.2% |
| o | 612 | 0.2% |
| c | 612 | 0.2% |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 92447 | |
| I | 612 | 0.7% |
| G | 183 | 0.2% |
Space Separator
| Value | Count | Frequency (%) |
| 46315 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 467068 | |
| Common | 46315 | 9.0% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| C | 92447 | |
| r | 92447 | |
| d | 92447 | |
| i | 46927 | |
| e | 46744 | |
| t | 46315 | |
| a | 46315 | |
| I | 612 | 0.1% |
| n | 612 | 0.1% |
| v | 612 | 0.1% |
| Other values (4) | 1590 | 0.3% |
Common
| Value | Count | Frequency (%) |
| 46315 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 513383 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| C | 92447 | |
| r | 92447 | |
| d | 92447 | |
| i | 46927 | |
| e | 46744 | |
| t | 46315 | |
| 46315 | ||
| a | 46315 | |
| I | 612 | 0.1% |
| n | 612 | 0.1% |
| Other values (5) | 2202 | 0.4% |
original_payment_currency
Categorical
| Distinct | 50 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 366.7 KiB |
| MYR | |
|---|---|
| KRW | |
| TWD | |
| USD | |
| THB | |
| Other values (45) |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 140781 |
|---|---|
| Distinct characters | 26 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | CNY |
|---|---|
| 2nd row | JPY |
| 3rd row | TWD |
| 4th row | TRY |
| 5th row | KRW |
Common Values
| Value | Count | Frequency (%) |
| MYR | 6088 | |
| KRW | 5995 | |
| TWD | 5300 | |
| USD | 3685 | 7.9% |
| THB | 3604 | 7.7% |
| CNY | 2908 | 6.2% |
| HKD | 2695 | 5.7% |
| JPY | 2677 | 5.7% |
| SGD | 1977 | 4.2% |
| IDR | 1908 | 4.1% |
| Other values (40) | 10090 |
Length
| Value | Count | Frequency (%) |
| myr | 6088 | |
| krw | 5995 | |
| twd | 5300 | |
| usd | 3685 | 7.9% |
| thb | 3604 | 7.7% |
| cny | 2908 | 6.2% |
| hkd | 2695 | 5.7% |
| jpy | 2677 | 5.7% |
| sgd | 1977 | 4.2% |
| idr | 1908 | 4.1% |
| Other values (40) | 10090 |
Most occurring characters
| Value | Count | Frequency (%) |
| D | 18718 | |
| R | 17659 | |
| Y | 11789 | 8.4% |
| W | 11352 | 8.1% |
| K | 9238 | 6.6% |
| T | 9034 | 6.4% |
| H | 8063 | 5.7% |
| U | 7111 | 5.1% |
| P | 6972 | 5.0% |
| S | 6444 | 4.6% |
| Other values (16) | 34401 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 140781 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| D | 18718 | |
| R | 17659 | |
| Y | 11789 | 8.4% |
| W | 11352 | 8.1% |
| K | 9238 | 6.6% |
| T | 9034 | 6.4% |
| H | 8063 | 5.7% |
| U | 7111 | 5.1% |
| P | 6972 | 5.0% |
| S | 6444 | 4.6% |
| Other values (16) | 34401 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 140781 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| D | 18718 | |
| R | 17659 | |
| Y | 11789 | 8.4% |
| W | 11352 | 8.1% |
| K | 9238 | 6.6% |
| T | 9034 | 6.4% |
| H | 8063 | 5.7% |
| U | 7111 | 5.1% |
| P | 6972 | 5.0% |
| S | 6444 | 4.6% |
| Other values (16) | 34401 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 140781 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| D | 18718 | |
| R | 17659 | |
| Y | 11789 | 8.4% |
| W | 11352 | 8.1% |
| K | 9238 | 6.6% |
| T | 9034 | 6.4% |
| H | 8063 | 5.7% |
| U | 7111 | 5.1% |
| P | 6972 | 5.0% |
| S | 6444 | 4.6% |
| Other values (16) | 34401 |
is_user_logged_in
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 46.0 KiB |
| True | |
|---|---|
| False |
| Value | Count | Frequency (%) |
| True | 30549 | |
| False | 16378 |
cancellation_policy_code
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 366.7 KiB |
| 2 | |
|---|---|
| 0 | |
| 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 46927 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 2 |
| 3rd row | 1 |
| 4th row | 0 |
| 5th row | 2 |
Common Values
| Value | Count | Frequency (%) |
| 2 | 20542 | |
| 0 | 13229 | |
| 1 | 13156 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 2 | 20542 | |
| 0 | 13229 | |
| 1 | 13156 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 20542 | |
| 0 | 13229 | |
| 1 | 13156 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 46927 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 20542 | |
| 0 | 13229 | |
| 1 | 13156 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 46927 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 2 | 20542 | |
| 0 | 13229 | |
| 1 | 13156 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 46927 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 2 | 20542 | |
| 0 | 13229 | |
| 1 | 13156 |
is_first_booking
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 46.0 KiB |
| False | |
|---|---|
| True |
| Value | Count | Frequency (%) |
| False | 36484 | |
| True | 10443 | 22.3% |
request_nonesmoke
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 366.7 KiB |
| 0.0 | |
|---|---|
| 1.0 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 140781 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 0.0 |
| 4th row | 0.0 |
| 5th row | 0.0 |
Common Values
| Value | Count | Frequency (%) |
| 0.0 | 27599 | |
| 1.0 | 19328 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0.0 | 27599 | |
| 1.0 | 19328 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 74526 | |
| . | 46927 | |
| 1 | 19328 | 13.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 93854 | |
| Other Punctuation | 46927 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 74526 | |
| 1 | 19328 | 20.6% |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 46927 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 140781 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 74526 | |
| . | 46927 | |
| 1 | 19328 | 13.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 140781 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 74526 | |
| . | 46927 | |
| 1 | 19328 | 13.7% |
request_latecheckin
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 366.7 KiB |
| 0.0 | |
|---|---|
| 1.0 | 702 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 140781 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 0.0 |
| 4th row | 0.0 |
| 5th row | 0.0 |
Common Values
| Value | Count | Frequency (%) |
| 0.0 | 46225 | |
| 1.0 | 702 | 1.5% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0.0 | 46225 | |
| 1.0 | 702 | 1.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 93152 | |
| . | 46927 | |
| 1 | 702 | 0.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 93854 | |
| Other Punctuation | 46927 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 93152 | |
| 1 | 702 | 0.7% |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 46927 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 140781 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 93152 | |
| . | 46927 | |
| 1 | 702 | 0.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 140781 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 93152 | |
| . | 46927 | |
| 1 | 702 | 0.5% |
request_highfloor
Categorical
HIGH CORRELATION  IMBALANCE 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 366.7 KiB |
| 0.0 | |
|---|---|
| 1.0 | 4053 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 140781 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 0.0 |
| 4th row | 0.0 |
| 5th row | 0.0 |
Common Values
| Value | Count | Frequency (%) |
| 0.0 | 42874 | |
| 1.0 | 4053 | 8.6% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0.0 | 42874 | |
| 1.0 | 4053 | 8.6% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 89801 | |
| . | 46927 | |
| 1 | 4053 | 2.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 93854 | |
| Other Punctuation | 46927 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 89801 | |
| 1 | 4053 | 4.3% |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 46927 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 140781 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 89801 | |
| . | 46927 | |
| 1 | 4053 | 2.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 140781 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 89801 | |
| . | 46927 | |
| 1 | 4053 | 2.9% |
request_largebed
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 366.7 KiB |
| 0.0 | |
|---|---|
| 1.0 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 140781 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 0.0 |
| 4th row | 1.0 |
| 5th row | 0.0 |
Common Values
| Value | Count | Frequency (%) |
| 0.0 | 36421 | |
| 1.0 | 10506 | 22.4% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0.0 | 36421 | |
| 1.0 | 10506 | 22.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 83348 | |
| . | 46927 | |
| 1 | 10506 | 7.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 93854 | |
| Other Punctuation | 46927 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 83348 | |
| 1 | 10506 | 11.2% |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 46927 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 140781 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 83348 | |
| . | 46927 | |
| 1 | 10506 | 7.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 140781 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 83348 | |
| . | 46927 | |
| 1 | 10506 | 7.5% |
request_twinbeds
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 366.7 KiB |
| 0.0 | |
|---|---|
| 1.0 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 140781 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 0.0 |
| 4th row | 0.0 |
| 5th row | 0.0 |
Common Values
| Value | Count | Frequency (%) |
| 0.0 | 42654 | |
| 1.0 | 4273 | 9.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0.0 | 42654 | |
| 1.0 | 4273 | 9.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 89581 | |
| . | 46927 | |
| 1 | 4273 | 3.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 93854 | |
| Other Punctuation | 46927 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 89581 | |
| 1 | 4273 | 4.6% |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 46927 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 140781 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 89581 | |
| . | 46927 | |
| 1 | 4273 | 3.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 140781 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 89581 | |
| . | 46927 | |
| 1 | 4273 | 3.0% |
request_airport
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 366.7 KiB |
| 0.0 | |
|---|---|
| 1.0 | 199 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 140781 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 0.0 |
| 4th row | 0.0 |
| 5th row | 0.0 |
Common Values
| Value | Count | Frequency (%) |
| 0.0 | 46728 | |
| 1.0 | 199 | 0.4% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0.0 | 46728 | |
| 1.0 | 199 | 0.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 93655 | |
| . | 46927 | |
| 1 | 199 | 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 93854 | |
| Other Punctuation | 46927 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 93655 | |
| 1 | 199 | 0.2% |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 46927 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 140781 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 93655 | |
| . | 46927 | |
| 1 | 199 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 140781 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 93655 | |
| . | 46927 | |
| 1 | 199 | 0.1% |
request_earlycheckin
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 366.7 KiB |
| 0.0 | |
|---|---|
| 1.0 | 901 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 140781 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 0.0 |
| 4th row | 0.0 |
| 5th row | 0.0 |
Common Values
| Value | Count | Frequency (%) |
| 0.0 | 46026 | |
| 1.0 | 901 | 1.9% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0.0 | 46026 | |
| 1.0 | 901 | 1.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 92953 | |
| . | 46927 | |
| 1 | 901 | 0.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 93854 | |
| Other Punctuation | 46927 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 92953 | |
| 1 | 901 | 1.0% |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 46927 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 140781 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 92953 | |
| . | 46927 | |
| 1 | 901 | 0.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 140781 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 92953 | |
| . | 46927 | |
| 1 | 901 | 0.6% |
hotel_area_code
Real number (ℝ)
| Distinct | 5057 |
|---|---|
| Distinct (%) | 10.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3025.0395 |
| Minimum | 1 |
|---|---|
| Maximum | 5896 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 366.7 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 243 |
| Q1 | 1477 |
| median | 3134 |
| Q3 | 4572 |
| 95-th percentile | 5602 |
| Maximum | 5896 |
| Range | 5895 |
| Interquartile range (IQR) | 3095 |
Descriptive statistics
| Standard deviation | 1733.8559 |
|---|---|
| Coefficient of variation (CV) | 0.573168 |
| Kurtosis | -1.2487545 |
| Mean | 3025.0395 |
| Median Absolute Deviation (MAD) | 1549 |
| Skewness | -0.11513251 |
| Sum | 1.4195603 × 108 |
| Variance | 3006256.2 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 3747 | 718 | 1.5% |
| 1192 | 571 | 1.2% |
| 643 | 419 | 0.9% |
| 4463 | 404 | 0.9% |
| 606 | 382 | 0.8% |
| 104 | 372 | 0.8% |
| 4364 | 342 | 0.7% |
| 3156 | 335 | 0.7% |
| 2553 | 322 | 0.7% |
| 5891 | 302 | 0.6% |
| Other values (5047) | 42760 |
| Value | Count | Frequency (%) |
| 1 | 1 | < 0.1% |
| 2 | 1 | < 0.1% |
| 3 | 1 | < 0.1% |
| 4 | 7 | |
| 5 | 1 | < 0.1% |
| 6 | 5 | |
| 7 | 1 | < 0.1% |
| 8 | 1 | < 0.1% |
| 9 | 7 | |
| 10 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 5896 | 1 | < 0.1% |
| 5894 | 2 | < 0.1% |
| 5893 | 1 | < 0.1% |
| 5892 | 2 | < 0.1% |
| 5891 | 302 | |
| 5890 | 1 | < 0.1% |
| 5889 | 18 | < 0.1% |
| 5888 | 1 | < 0.1% |
| 5887 | 39 | 0.1% |
| 5886 | 10 | < 0.1% |
hotel_city_code
Real number (ℝ)
| Distinct | 2402 |
|---|---|
| Distinct (%) | 5.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1498.0466 |
| Minimum | 0 |
|---|---|
| Maximum | 2808 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 366.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 140 |
| Q1 | 583 |
| median | 1572 |
| Q3 | 2310 |
| 95-th percentile | 2797 |
| Maximum | 2808 |
| Range | 2808 |
| Interquartile range (IQR) | 1727 |
Descriptive statistics
| Standard deviation | 909.02087 |
|---|---|
| Coefficient of variation (CV) | 0.60680414 |
| Kurtosis | -1.4051834 |
| Mean | 1498.0466 |
| Median Absolute Deviation (MAD) | 875 |
| Skewness | -0.16917617 |
| Sum | 70298832 |
| Variance | 826318.94 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2477 | 2525 | 5.4% |
| 2797 | 1883 | 4.0% |
| 1403 | 1794 | 3.8% |
| 142 | 1295 | 2.8% |
| 162 | 1163 | 2.5% |
| 2249 | 1124 | 2.4% |
| 437 | 1059 | 2.3% |
| 2799 | 987 | 2.1% |
| 1816 | 881 | 1.9% |
| 2310 | 767 | 1.6% |
| Other values (2392) | 33449 |
| Value | Count | Frequency (%) |
| 0 | 1 | < 0.1% |
| 1 | 2 | < 0.1% |
| 3 | 10 | < 0.1% |
| 4 | 2 | < 0.1% |
| 5 | 20 | |
| 6 | 3 | < 0.1% |
| 8 | 29 | |
| 9 | 1 | < 0.1% |
| 10 | 2 | < 0.1% |
| 11 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 2808 | 2 | < 0.1% |
| 2807 | 3 | < 0.1% |
| 2806 | 1 | < 0.1% |
| 2805 | 1 | < 0.1% |
| 2804 | 2 | < 0.1% |
| 2803 | 1 | < 0.1% |
| 2802 | 1 | < 0.1% |
| 2800 | 10 | < 0.1% |
| 2799 | 987 | |
| 2797 | 1883 |
has_request
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 366.7 KiB |
| 0.0 | |
|---|---|
| 2.0 | |
| 1.0 | |
| 3.0 | |
| 4.0 | 447 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 140781 |
|---|---|
| Distinct characters | 6 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 0.0 |
| 4th row | 1.0 |
| 5th row | 0.0 |
Common Values
| Value | Count | Frequency (%) |
| 0.0 | 23695 | |
| 2.0 | 10145 | |
| 1.0 | 10018 | |
| 3.0 | 2622 | 5.6% |
| 4.0 | 447 | 1.0% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0.0 | 23695 | |
| 2.0 | 10145 | |
| 1.0 | 10018 | |
| 3.0 | 2622 | 5.6% |
| 4.0 | 447 | 1.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 70622 | |
| . | 46927 | |
| 2 | 10145 | 7.2% |
| 1 | 10018 | 7.1% |
| 3 | 2622 | 1.9% |
| 4 | 447 | 0.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 93854 | |
| Other Punctuation | 46927 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 70622 | |
| 2 | 10145 | 10.8% |
| 1 | 10018 | 10.7% |
| 3 | 2622 | 2.8% |
| 4 | 447 | 0.5% |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 46927 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 140781 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 70622 | |
| . | 46927 | |
| 2 | 10145 | 7.2% |
| 1 | 10018 | 7.1% |
| 3 | 2622 | 1.9% |
| 4 | 447 | 0.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 140781 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 70622 | |
| . | 46927 | |
| 2 | 10145 | 7.2% |
| 1 | 10018 | 7.1% |
| 3 | 2622 | 1.9% |
| 4 | 447 | 0.3% |
distance_booking_checkin
Real number (ℝ)
| Distinct | 30473 |
|---|---|
| Distinct (%) | 64.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 29.655487 |
| Minimum | -1.6659722 |
|---|---|
| Maximum | 447.20972 |
| Zeros | 5 |
| Zeros (%) | < 0.1% |
| Negative | 7870 |
| Negative (%) | 16.8% |
| Memory size | 366.7 KiB |
Quantile statistics
| Minimum | -1.6659722 |
|---|---|
| 5-th percentile | -0.71944444 |
| Q1 | 0.62465278 |
| median | 9.8777778 |
| Q3 | 37.042014 |
| 95-th percentile | 132.92396 |
| Maximum | 447.20972 |
| Range | 448.87569 |
| Interquartile range (IQR) | 36.417361 |
Descriptive statistics
| Standard deviation | 46.847247 |
|---|---|
| Coefficient of variation (CV) | 1.579716 |
| Kurtosis | 7.9211162 |
| Mean | 29.655487 |
| Median Absolute Deviation (MAD) | 10.283333 |
| Skewness | 2.555511 |
| Sum | 1391643 |
| Variance | 2194.6646 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| -0.5597222222 | 18 | < 0.1% |
| -0.5256944444 | 16 | < 0.1% |
| -0.625 | 16 | < 0.1% |
| -0.4513888889 | 16 | < 0.1% |
| -0.6902777778 | 16 | < 0.1% |
| -0.4083333333 | 15 | < 0.1% |
| -0.4805555556 | 15 | < 0.1% |
| -0.4722222222 | 15 | < 0.1% |
| 0.09027777778 | 14 | < 0.1% |
| -0.6243055556 | 14 | < 0.1% |
| Other values (30463) | 46772 |
| Value | Count | Frequency (%) |
| -1.665972222 | 1 | |
| -1.575694444 | 1 | |
| -1.572916667 | 1 | |
| -1.544444444 | 1 | |
| -1.533333333 | 1 | |
| -1.523611111 | 1 | |
| -1.502777778 | 1 | |
| -1.498611111 | 1 | |
| -1.491666667 | 1 | |
| -1.484722222 | 1 |
| Value | Count | Frequency (%) |
| 447.2097222 | 1 | |
| 361.9833333 | 1 | |
| 361.7388889 | 1 | |
| 361.4763889 | 1 | |
| 359.23125 | 1 | |
| 357.0472222 | 1 | |
| 356.2979167 | 1 | |
| 355.4930556 | 1 | |
| 353.1513889 | 1 | |
| 350.5215278 | 1 |
amount_guests
Real number (ℝ)
| Distinct | 23 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.4957061 |
| Minimum | 1 |
|---|---|
| Maximum | 30 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 366.7 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 2 |
| Q3 | 3 |
| 95-th percentile | 5 |
| Maximum | 30 |
| Range | 29 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 1.4588569 |
|---|---|
| Coefficient of variation (CV) | 0.58454674 |
| Kurtosis | 26.962429 |
| Mean | 2.4957061 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 3.7545332 |
| Sum | 117116 |
| Variance | 2.1282633 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2 | 29487 | |
| 4 | 5766 | 12.3% |
| 1 | 5140 | 11.0% |
| 3 | 3851 | 8.2% |
| 6 | 1116 | 2.4% |
| 5 | 707 | 1.5% |
| 8 | 353 | 0.8% |
| 7 | 125 | 0.3% |
| 10 | 120 | 0.3% |
| 9 | 77 | 0.2% |
| Other values (13) | 185 | 0.4% |
| Value | Count | Frequency (%) |
| 1 | 5140 | 11.0% |
| 2 | 29487 | |
| 3 | 3851 | 8.2% |
| 4 | 5766 | 12.3% |
| 5 | 707 | 1.5% |
| 6 | 1116 | 2.4% |
| 7 | 125 | 0.3% |
| 8 | 353 | 0.8% |
| 9 | 77 | 0.2% |
| 10 | 120 | 0.3% |
| Value | Count | Frequency (%) |
| 30 | 1 | < 0.1% |
| 27 | 2 | < 0.1% |
| 24 | 1 | < 0.1% |
| 21 | 1 | < 0.1% |
| 20 | 6 | < 0.1% |
| 18 | 17 | |
| 17 | 3 | < 0.1% |
| 16 | 16 | |
| 15 | 6 | < 0.1% |
| 14 | 22 |
amount_nights
Real number (ℝ)
| Distinct | 29 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.993671 |
| Minimum | 1 |
|---|---|
| Maximum | 30 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 366.7 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 2 |
| 95-th percentile | 5 |
| Maximum | 30 |
| Range | 29 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 1.7459906 |
|---|---|
| Coefficient of variation (CV) | 0.87576665 |
| Kurtosis | 44.530156 |
| Mean | 1.993671 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 4.7506128 |
| Sum | 93557 |
| Variance | 3.0484831 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 25336 | |
| 2 | 10657 | |
| 3 | 5353 | 11.4% |
| 4 | 2625 | 5.6% |
| 5 | 1275 | 2.7% |
| 6 | 550 | 1.2% |
| 7 | 513 | 1.1% |
| 8 | 158 | 0.3% |
| 10 | 116 | 0.2% |
| 9 | 101 | 0.2% |
| Other values (19) | 243 | 0.5% |
| Value | Count | Frequency (%) |
| 1 | 25336 | |
| 2 | 10657 | |
| 3 | 5353 | 11.4% |
| 4 | 2625 | 5.6% |
| 5 | 1275 | 2.7% |
| 6 | 550 | 1.2% |
| 7 | 513 | 1.1% |
| 8 | 158 | 0.3% |
| 9 | 101 | 0.2% |
| 10 | 116 | 0.2% |
| Value | Count | Frequency (%) |
| 30 | 11 | |
| 29 | 1 | < 0.1% |
| 28 | 7 | |
| 27 | 2 | < 0.1% |
| 26 | 2 | < 0.1% |
| 25 | 1 | < 0.1% |
| 23 | 3 | < 0.1% |
| 22 | 1 | < 0.1% |
| 21 | 10 | |
| 20 | 12 |
price_per_guest_per_night
Real number (ℝ)
| Distinct | 26848 |
|---|---|
| Distinct (%) | 57.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 44.164547 |
| Minimum | 0.083333333 |
|---|---|
| Maximum | 1770.22 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 366.7 KiB |
Quantile statistics
| Minimum | 0.083333333 |
|---|---|
| 5-th percentile | 7.805 |
| Q1 | 17.13875 |
| median | 31.22 |
| Q3 | 54.9525 |
| 95-th percentile | 122.70175 |
| Maximum | 1770.22 |
| Range | 1770.1367 |
| Interquartile range (IQR) | 37.81375 |
Descriptive statistics
| Standard deviation | 45.586819 |
|---|---|
| Coefficient of variation (CV) | 1.0322039 |
| Kurtosis | 80.290278 |
| Mean | 44.164547 |
| Median Absolute Deviation (MAD) | 16.725 |
| Skewness | 5.1722562 |
| Sum | 2072509.7 |
| Variance | 2078.1581 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 6.5 | 16 | < 0.1% |
| 9.78 | 15 | < 0.1% |
| 6 | 14 | < 0.1% |
| 26.17 | 14 | < 0.1% |
| 7 | 13 | < 0.1% |
| 15 | 13 | < 0.1% |
| 122.63 | 13 | < 0.1% |
| 13.5 | 13 | < 0.1% |
| 7.5 | 13 | < 0.1% |
| 14.23 | 12 | < 0.1% |
| Other values (26838) | 46791 |
| Value | Count | Frequency (%) |
| 0.08333333333 | 1 | |
| 0.1923333333 | 1 | |
| 0.4233333333 | 1 | |
| 0.4875 | 1 | |
| 0.545 | 1 | |
| 0.570625 | 1 | |
| 0.6796875 | 1 | |
| 0.8333333333 | 1 | |
| 0.9225 | 1 | |
| 1 | 1 |
| Value | Count | Frequency (%) |
| 1770.22 | 1 | |
| 1167.215 | 1 | |
| 915.3983333 | 1 | |
| 813.24 | 1 | |
| 739.645 | 1 | |
| 733.425 | 1 | |
| 730.28 | 1 | |
| 717.035 | 1 | |
| 715.705 | 1 | |
| 686.415 | 1 |
costumer_guest_same_nation
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 46.0 KiB |
| False | |
|---|---|
| True |
| Value | Count | Frequency (%) |
| False | 41347 | |
| True | 5580 | 11.9% |
pay_now
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 46.0 KiB |
| True | |
|---|---|
| False |
| Value | Count | Frequency (%) |
| True | 35335 | |
| False | 11592 | 24.7% |
is_cancel
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 46.0 KiB |
| False | |
|---|---|
| True |
| Value | Count | Frequency (%) |
| False | 34250 | |
| True | 12677 | 27.0% |
| h_booking_id | booking_datetime | checkin_date | checkout_date | hotel_id | hotel_country_code | hotel_star_rating | accommadation_type_name | no_of_adults | no_of_children | no_of_room | origin_country_code | language | original_selling_amount | hotel_area_code | hotel_city_code | distance_booking_checkin | amount_guests | amount_nights | price_per_guest_per_night | guest_is_not_the_customer | no_of_extra_bed | original_payment_method | original_payment_type | original_payment_currency | is_user_logged_in | cancellation_policy_code | is_first_booking | request_nonesmoke | request_latecheckin | request_highfloor | request_largebed | request_twinbeds | request_airport | request_earlycheckin | has_request | costumer_guest_same_nation | pay_now | is_cancel | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| h_booking_id | 1.000 | 0.000 | -0.007 | -0.007 | -0.003 | -0.001 | 0.004 | 0.005 | 0.003 | 0.001 | 0.007 | -0.001 | 0.009 | 0.006 | -0.000 | 0.002 | -0.003 | 0.003 | 0.003 | 0.005 | 0.008 | 0.003 | 0.004 | 0.000 | 0.009 | 0.000 | 0.004 | 0.000 | 0.000 | 0.000 | 0.007 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.004 |
| booking_datetime | 0.000 | 1.000 | 0.648 | 0.637 | 0.049 | 0.067 | -0.067 | -0.053 | -0.088 | -0.105 | -0.070 | 0.051 | -0.092 | -0.318 | 0.021 | -0.017 | -0.614 | -0.121 | -0.242 | -0.202 | 0.048 | 0.020 | 0.048 | 0.028 | 0.085 | 0.113 | 0.076 | 0.026 | 0.251 | 0.041 | 0.043 | 0.178 | 0.065 | 0.050 | 0.034 | 0.142 | 0.066 | 0.282 | 0.265 |
| checkin_date | -0.007 | 0.648 | 1.000 | 0.998 | 0.037 | -0.009 | -0.014 | -0.013 | -0.034 | -0.044 | -0.029 | -0.012 | -0.031 | -0.076 | 0.008 | 0.003 | -0.010 | -0.048 | -0.070 | -0.029 | 0.014 | 0.008 | 0.020 | 0.013 | 0.056 | 0.011 | 0.017 | 0.012 | 0.182 | 0.020 | 0.024 | 0.122 | 0.051 | 0.014 | 0.021 | 0.098 | 0.016 | 0.026 | 0.021 |
| checkout_date | -0.007 | 0.637 | 0.998 | 1.000 | 0.036 | -0.014 | -0.013 | -0.013 | -0.035 | -0.043 | -0.028 | -0.018 | -0.035 | -0.044 | 0.007 | 0.004 | 0.006 | -0.049 | -0.019 | -0.023 | 0.016 | 0.011 | 0.023 | 0.016 | 0.055 | 0.015 | 0.016 | 0.006 | 0.181 | 0.020 | 0.021 | 0.120 | 0.051 | 0.012 | 0.019 | 0.097 | 0.009 | 0.023 | 0.022 |
| hotel_id | -0.003 | 0.049 | 0.037 | 0.036 | 1.000 | 0.071 | -0.171 | -0.154 | -0.022 | -0.048 | -0.031 | 0.064 | 0.032 | -0.110 | 0.006 | 0.026 | -0.034 | -0.038 | -0.021 | -0.118 | 0.041 | 0.028 | 0.066 | 0.062 | 0.067 | 0.058 | 0.160 | 0.022 | 0.021 | 0.014 | 0.026 | 0.029 | 0.022 | 0.004 | 0.014 | 0.023 | 0.035 | 0.163 | 0.117 |
| hotel_country_code | -0.001 | 0.067 | -0.009 | -0.014 | 0.071 | 1.000 | -0.077 | 0.027 | 0.105 | 0.003 | 0.004 | 0.475 | 0.132 | -0.176 | 0.013 | 0.067 | -0.106 | 0.095 | -0.074 | -0.243 | 0.107 | 0.023 | 0.144 | 0.103 | 0.463 | 0.075 | 0.208 | 0.096 | 0.041 | 0.059 | 0.040 | 0.097 | 0.021 | 0.018 | 0.042 | 0.044 | 0.144 | 0.212 | 0.200 |
| hotel_star_rating | 0.004 | -0.067 | -0.014 | -0.013 | -0.171 | -0.077 | 1.000 | 0.328 | 0.094 | 0.078 | 0.036 | -0.099 | 0.008 | 0.445 | -0.002 | -0.024 | 0.112 | 0.115 | 0.060 | 0.509 | 0.048 | 0.021 | 0.100 | 0.055 | 0.108 | 0.029 | 0.101 | 0.038 | 0.023 | 0.011 | 0.132 | 0.089 | 0.072 | 0.028 | 0.045 | 0.072 | 0.037 | 0.096 | 0.051 |
| accommadation_type_name | 0.005 | -0.053 | -0.013 | -0.013 | -0.154 | 0.027 | 0.328 | 1.000 | 0.152 | 0.063 | 0.030 | -0.007 | -0.013 | 0.222 | -0.017 | -0.001 | 0.069 | 0.158 | 0.016 | 0.215 | 0.045 | 0.028 | 0.055 | 0.022 | 0.086 | 0.022 | 0.087 | 0.040 | 0.043 | 0.016 | 0.071 | 0.049 | 0.046 | 0.026 | 0.023 | 0.041 | 0.033 | 0.046 | 0.062 |
| no_of_adults | 0.003 | -0.088 | -0.034 | -0.035 | -0.022 | 0.105 | 0.094 | 0.152 | 1.000 | 0.047 | 0.529 | 0.089 | 0.016 | 0.258 | 0.012 | 0.013 | 0.119 | 0.903 | 0.010 | -0.100 | 0.032 | 0.106 | 0.000 | 0.019 | 0.036 | 0.018 | 0.027 | 0.008 | 0.022 | 0.000 | 0.009 | 0.069 | 0.058 | 0.022 | 0.000 | 0.014 | 0.008 | 0.059 | 0.045 |
| no_of_children | 0.001 | -0.105 | -0.044 | -0.043 | -0.048 | 0.003 | 0.078 | 0.063 | 0.047 | 1.000 | 0.064 | -0.009 | 0.058 | 0.161 | -0.018 | 0.017 | 0.125 | 0.432 | 0.049 | -0.015 | 0.020 | 0.037 | 0.025 | 0.007 | 0.044 | 0.006 | 0.016 | 0.038 | 0.017 | 0.006 | 0.008 | 0.046 | 0.019 | 0.011 | 0.020 | 0.011 | 0.014 | 0.091 | 0.043 |
| no_of_room | 0.007 | -0.070 | -0.029 | -0.028 | -0.031 | 0.004 | 0.036 | 0.030 | 0.529 | 0.064 | 1.000 | 0.016 | 0.015 | 0.219 | -0.005 | -0.011 | 0.085 | 0.499 | 0.034 | 0.008 | 0.044 | 0.102 | 0.008 | 0.010 | 0.035 | 0.020 | 0.006 | 0.008 | 0.011 | 0.000 | 0.007 | 0.031 | 0.053 | 0.022 | 0.000 | 0.005 | 0.021 | 0.047 | 0.027 |
| origin_country_code | -0.001 | 0.051 | -0.012 | -0.018 | 0.064 | 0.475 | -0.099 | -0.007 | 0.089 | -0.009 | 0.016 | 1.000 | 0.095 | -0.131 | 0.020 | 0.021 | -0.102 | 0.075 | -0.092 | -0.154 | 0.131 | 0.020 | 0.225 | 0.310 | 0.806 | 0.079 | 0.101 | 0.119 | 0.079 | 0.051 | 0.091 | 0.109 | 0.058 | 0.032 | 0.051 | 0.065 | 0.219 | 0.137 | 0.141 |
| language | 0.009 | -0.092 | -0.031 | -0.035 | 0.032 | 0.132 | 0.008 | -0.013 | 0.016 | 0.058 | 0.015 | 0.095 | 1.000 | 0.043 | -0.034 | -0.040 | 0.124 | 0.036 | -0.067 | 0.088 | 0.127 | 0.015 | 0.241 | 0.286 | 0.672 | 0.150 | 0.104 | 0.132 | 0.096 | 0.065 | 0.048 | 0.127 | 0.044 | 0.029 | 0.070 | 0.069 | 0.144 | 0.168 | 0.131 |
| original_selling_amount | 0.006 | -0.318 | -0.076 | -0.044 | -0.110 | -0.176 | 0.445 | 0.222 | 0.258 | 0.161 | 0.219 | -0.131 | 0.043 | 1.000 | -0.032 | -0.042 | 0.458 | 0.298 | 0.612 | 0.752 | 0.013 | 0.000 | 0.000 | 0.000 | 0.034 | 0.000 | 0.004 | 0.000 | 0.010 | 0.000 | 0.000 | 0.000 | 0.000 | 0.013 | 0.000 | 0.000 | 0.000 | 0.013 | 0.018 |
| hotel_area_code | -0.000 | 0.021 | 0.008 | 0.007 | 0.006 | 0.013 | -0.002 | -0.017 | 0.012 | -0.018 | -0.005 | 0.020 | -0.034 | -0.032 | 1.000 | 0.013 | -0.020 | 0.006 | -0.000 | -0.044 | 0.050 | 0.011 | 0.037 | 0.100 | 0.078 | 0.035 | 0.049 | 0.024 | 0.019 | 0.019 | 0.033 | 0.013 | 0.017 | 0.021 | 0.006 | 0.016 | 0.015 | 0.041 | 0.033 |
| hotel_city_code | 0.002 | -0.017 | 0.003 | 0.004 | 0.026 | 0.067 | -0.024 | -0.001 | 0.013 | 0.017 | -0.011 | 0.021 | -0.040 | -0.042 | 0.013 | 1.000 | 0.017 | 0.017 | 0.009 | -0.070 | 0.061 | 0.015 | 0.055 | 0.095 | 0.172 | 0.040 | 0.108 | 0.053 | 0.014 | 0.022 | 0.034 | 0.017 | 0.004 | 0.019 | 0.028 | 0.022 | 0.057 | 0.072 | 0.053 |
| distance_booking_checkin | -0.003 | -0.614 | -0.010 | 0.006 | -0.034 | -0.106 | 0.112 | 0.069 | 0.119 | 0.125 | 0.085 | -0.102 | 0.124 | 0.458 | -0.020 | 0.017 | 1.000 | 0.158 | 0.343 | 0.309 | 0.045 | 0.008 | 0.040 | 0.027 | 0.081 | 0.122 | 0.075 | 0.030 | 0.174 | 0.031 | 0.047 | 0.130 | 0.040 | 0.042 | 0.024 | 0.101 | 0.061 | 0.289 | 0.279 |
| amount_guests | 0.003 | -0.121 | -0.048 | -0.049 | -0.038 | 0.095 | 0.115 | 0.158 | 0.903 | 0.432 | 0.499 | 0.075 | 0.036 | 0.298 | 0.006 | 0.017 | 0.158 | 1.000 | 0.029 | -0.099 | 0.030 | 0.116 | 0.000 | 0.024 | 0.039 | 0.014 | 0.033 | 0.030 | 0.024 | 0.000 | 0.011 | 0.085 | 0.061 | 0.020 | 0.000 | 0.017 | 0.013 | 0.096 | 0.059 |
| amount_nights | 0.003 | -0.242 | -0.070 | -0.019 | -0.021 | -0.074 | 0.060 | 0.016 | 0.010 | 0.049 | 0.034 | -0.092 | -0.067 | 0.612 | -0.000 | 0.009 | 0.343 | 0.029 | 1.000 | 0.134 | 0.032 | 0.000 | 0.007 | 0.012 | 0.088 | 0.018 | 0.014 | 0.034 | 0.032 | 0.010 | 0.040 | 0.014 | 0.009 | 0.044 | 0.000 | 0.022 | 0.033 | 0.095 | 0.112 |
| price_per_guest_per_night | 0.005 | -0.202 | -0.029 | -0.023 | -0.118 | -0.243 | 0.509 | 0.215 | -0.100 | -0.015 | 0.008 | -0.154 | 0.088 | 0.752 | -0.044 | -0.070 | 0.309 | -0.099 | 0.134 | 1.000 | 0.015 | 0.000 | 0.000 | 0.079 | 0.036 | 0.013 | 0.036 | 0.000 | 0.018 | 0.008 | 0.000 | 0.013 | 0.010 | 0.000 | 0.000 | 0.013 | 0.020 | 0.028 | 0.041 |
| guest_is_not_the_customer | 0.008 | 0.048 | 0.014 | 0.016 | 0.041 | 0.107 | 0.048 | 0.045 | 0.032 | 0.020 | 0.044 | 0.131 | 0.127 | 0.013 | 0.050 | 0.061 | 0.045 | 0.030 | 0.032 | 0.015 | 1.000 | 0.014 | 0.079 | 0.082 | 0.199 | 0.046 | 0.018 | 0.162 | 0.051 | 0.008 | 0.000 | 0.027 | 0.048 | 0.002 | 0.015 | 0.065 | 0.044 | 0.044 | 0.046 |
| no_of_extra_bed | 0.003 | 0.020 | 0.008 | 0.011 | 0.028 | 0.023 | 0.021 | 0.028 | 0.106 | 0.037 | 0.102 | 0.020 | 0.015 | 0.000 | 0.011 | 0.015 | 0.008 | 0.116 | 0.000 | 0.000 | 0.014 | 1.000 | 0.000 | 0.000 | 0.047 | 0.000 | 0.015 | 0.013 | 0.000 | 0.013 | 0.000 | 0.016 | 0.027 | 0.035 | 0.012 | 0.000 | 0.000 | 0.034 | 0.000 |
| original_payment_method | 0.004 | 0.048 | 0.020 | 0.023 | 0.066 | 0.144 | 0.100 | 0.055 | 0.000 | 0.025 | 0.008 | 0.225 | 0.241 | 0.000 | 0.037 | 0.055 | 0.040 | 0.000 | 0.007 | 0.000 | 0.079 | 0.000 | 1.000 | 0.341 | 0.163 | 0.123 | 0.115 | 0.096 | 0.080 | 0.027 | 0.078 | 0.115 | 0.058 | 0.009 | 0.036 | 0.072 | 0.096 | 0.237 | 0.148 |
| original_payment_type | 0.000 | 0.028 | 0.013 | 0.016 | 0.062 | 0.103 | 0.055 | 0.022 | 0.019 | 0.007 | 0.010 | 0.310 | 0.286 | 0.000 | 0.100 | 0.095 | 0.027 | 0.024 | 0.012 | 0.079 | 0.082 | 0.000 | 0.341 | 1.000 | 0.316 | 0.163 | 0.031 | 0.053 | 0.096 | 0.013 | 0.036 | 0.062 | 0.036 | 0.004 | 0.015 | 0.081 | 0.041 | 0.068 | 0.053 |
| original_payment_currency | 0.009 | 0.085 | 0.056 | 0.055 | 0.067 | 0.463 | 0.108 | 0.086 | 0.036 | 0.044 | 0.035 | 0.806 | 0.672 | 0.034 | 0.078 | 0.172 | 0.081 | 0.039 | 0.088 | 0.036 | 0.199 | 0.047 | 0.163 | 0.316 | 1.000 | 0.199 | 0.135 | 0.218 | 0.099 | 0.068 | 0.153 | 0.147 | 0.074 | 0.117 | 0.090 | 0.097 | 0.394 | 0.205 | 0.177 |
| is_user_logged_in | 0.000 | 0.113 | 0.011 | 0.015 | 0.058 | 0.075 | 0.029 | 0.022 | 0.018 | 0.006 | 0.020 | 0.079 | 0.150 | 0.000 | 0.035 | 0.040 | 0.122 | 0.014 | 0.018 | 0.013 | 0.046 | 0.000 | 0.123 | 0.163 | 0.199 | 1.000 | 0.046 | 0.479 | 0.034 | 0.032 | 0.072 | 0.044 | 0.018 | 0.000 | 0.036 | 0.092 | 0.032 | 0.096 | 0.095 |
| cancellation_policy_code | 0.004 | 0.076 | 0.017 | 0.016 | 0.160 | 0.208 | 0.101 | 0.087 | 0.027 | 0.016 | 0.006 | 0.101 | 0.104 | 0.004 | 0.049 | 0.108 | 0.075 | 0.033 | 0.014 | 0.036 | 0.018 | 0.015 | 0.115 | 0.031 | 0.135 | 0.046 | 1.000 | 0.025 | 0.030 | 0.004 | 0.020 | 0.066 | 0.017 | 0.012 | 0.022 | 0.044 | 0.033 | 0.358 | 0.313 |
| is_first_booking | 0.000 | 0.026 | 0.012 | 0.006 | 0.022 | 0.096 | 0.038 | 0.040 | 0.008 | 0.038 | 0.008 | 0.119 | 0.132 | 0.000 | 0.024 | 0.053 | 0.030 | 0.030 | 0.034 | 0.000 | 0.162 | 0.013 | 0.096 | 0.053 | 0.218 | 0.479 | 0.025 | 1.000 | 0.041 | 0.025 | 0.044 | 0.039 | 0.022 | 0.024 | 0.026 | 0.076 | 0.179 | 0.038 | 0.012 |
| request_nonesmoke | 0.000 | 0.251 | 0.182 | 0.181 | 0.021 | 0.041 | 0.023 | 0.043 | 0.022 | 0.017 | 0.011 | 0.079 | 0.096 | 0.010 | 0.019 | 0.014 | 0.174 | 0.024 | 0.032 | 0.018 | 0.051 | 0.000 | 0.080 | 0.096 | 0.099 | 0.034 | 0.030 | 0.041 | 1.000 | 0.046 | 0.217 | 0.391 | 0.242 | 0.029 | 0.060 | 0.861 | 0.020 | 0.021 | 0.059 |
| request_latecheckin | 0.000 | 0.041 | 0.020 | 0.020 | 0.014 | 0.059 | 0.011 | 0.016 | 0.000 | 0.006 | 0.000 | 0.051 | 0.065 | 0.000 | 0.019 | 0.022 | 0.031 | 0.000 | 0.010 | 0.008 | 0.008 | 0.013 | 0.027 | 0.013 | 0.068 | 0.032 | 0.004 | 0.025 | 0.046 | 1.000 | 0.136 | 0.084 | 0.021 | 0.005 | 0.016 | 0.332 | 0.007 | 0.019 | 0.018 |
| request_highfloor | 0.007 | 0.043 | 0.024 | 0.021 | 0.026 | 0.040 | 0.132 | 0.071 | 0.009 | 0.008 | 0.007 | 0.091 | 0.048 | 0.000 | 0.033 | 0.034 | 0.047 | 0.011 | 0.040 | 0.000 | 0.000 | 0.000 | 0.078 | 0.036 | 0.153 | 0.072 | 0.020 | 0.044 | 0.217 | 0.136 | 1.000 | 0.253 | 0.115 | 0.044 | 0.195 | 0.766 | 0.010 | 0.035 | 0.010 |
| request_largebed | 0.000 | 0.178 | 0.122 | 0.120 | 0.029 | 0.097 | 0.089 | 0.049 | 0.069 | 0.046 | 0.031 | 0.109 | 0.127 | 0.000 | 0.013 | 0.017 | 0.130 | 0.085 | 0.014 | 0.013 | 0.027 | 0.016 | 0.115 | 0.062 | 0.147 | 0.044 | 0.066 | 0.039 | 0.391 | 0.084 | 0.253 | 1.000 | 0.170 | 0.041 | 0.090 | 0.680 | 0.000 | 0.042 | 0.082 |
| request_twinbeds | 0.000 | 0.065 | 0.051 | 0.051 | 0.022 | 0.021 | 0.072 | 0.046 | 0.058 | 0.019 | 0.053 | 0.058 | 0.044 | 0.000 | 0.017 | 0.004 | 0.040 | 0.061 | 0.009 | 0.010 | 0.048 | 0.027 | 0.058 | 0.036 | 0.074 | 0.018 | 0.017 | 0.022 | 0.242 | 0.021 | 0.115 | 0.170 | 1.000 | 0.008 | 0.039 | 0.400 | 0.000 | 0.020 | 0.008 |
| request_airport | 0.000 | 0.050 | 0.014 | 0.012 | 0.004 | 0.018 | 0.028 | 0.026 | 0.022 | 0.011 | 0.022 | 0.032 | 0.029 | 0.013 | 0.021 | 0.019 | 0.042 | 0.020 | 0.044 | 0.000 | 0.002 | 0.035 | 0.009 | 0.004 | 0.117 | 0.000 | 0.012 | 0.024 | 0.029 | 0.005 | 0.044 | 0.041 | 0.008 | 1.000 | 0.006 | 0.165 | 0.010 | 0.016 | 0.000 |
| request_earlycheckin | 0.000 | 0.034 | 0.021 | 0.019 | 0.014 | 0.042 | 0.045 | 0.023 | 0.000 | 0.020 | 0.000 | 0.051 | 0.070 | 0.000 | 0.006 | 0.028 | 0.024 | 0.000 | 0.000 | 0.000 | 0.015 | 0.012 | 0.036 | 0.015 | 0.090 | 0.036 | 0.022 | 0.026 | 0.060 | 0.016 | 0.195 | 0.090 | 0.039 | 0.006 | 1.000 | 0.423 | 0.000 | 0.000 | 0.007 |
| has_request | 0.000 | 0.142 | 0.098 | 0.097 | 0.023 | 0.044 | 0.072 | 0.041 | 0.014 | 0.011 | 0.005 | 0.065 | 0.069 | 0.000 | 0.016 | 0.022 | 0.101 | 0.017 | 0.022 | 0.013 | 0.065 | 0.000 | 0.072 | 0.081 | 0.097 | 0.092 | 0.044 | 0.076 | 0.861 | 0.332 | 0.766 | 0.680 | 0.400 | 0.165 | 0.423 | 1.000 | 0.012 | 0.058 | 0.083 |
| costumer_guest_same_nation | 0.000 | 0.066 | 0.016 | 0.009 | 0.035 | 0.144 | 0.037 | 0.033 | 0.008 | 0.014 | 0.021 | 0.219 | 0.144 | 0.000 | 0.015 | 0.057 | 0.061 | 0.013 | 0.033 | 0.020 | 0.044 | 0.000 | 0.096 | 0.041 | 0.394 | 0.032 | 0.033 | 0.179 | 0.020 | 0.007 | 0.010 | 0.000 | 0.000 | 0.010 | 0.000 | 0.012 | 1.000 | 0.047 | 0.018 |
| pay_now | 0.000 | 0.282 | 0.026 | 0.023 | 0.163 | 0.212 | 0.096 | 0.046 | 0.059 | 0.091 | 0.047 | 0.137 | 0.168 | 0.013 | 0.041 | 0.072 | 0.289 | 0.096 | 0.095 | 0.028 | 0.044 | 0.034 | 0.237 | 0.068 | 0.205 | 0.096 | 0.358 | 0.038 | 0.021 | 0.019 | 0.035 | 0.042 | 0.020 | 0.016 | 0.000 | 0.058 | 0.047 | 1.000 | 0.387 |
| is_cancel | 0.004 | 0.265 | 0.021 | 0.022 | 0.117 | 0.200 | 0.051 | 0.062 | 0.045 | 0.043 | 0.027 | 0.141 | 0.131 | 0.018 | 0.033 | 0.053 | 0.279 | 0.059 | 0.112 | 0.041 | 0.046 | 0.000 | 0.148 | 0.053 | 0.177 | 0.095 | 0.313 | 0.012 | 0.059 | 0.018 | 0.010 | 0.082 | 0.008 | 0.000 | 0.007 | 0.083 | 0.018 | 0.387 | 1.000 |
| h_booking_id | booking_datetime | checkin_date | checkout_date | hotel_id | hotel_country_code | hotel_live_date | hotel_star_rating | accommadation_type_name | customer_nationality | guest_is_not_the_customer | guest_nationality_country_name | no_of_adults | no_of_children | no_of_extra_bed | no_of_room | origin_country_code | language | original_selling_amount | original_payment_method | original_payment_type | original_payment_currency | is_user_logged_in | cancellation_policy_code | is_first_booking | request_nonesmoke | request_latecheckin | request_highfloor | request_largebed | request_twinbeds | request_airport | request_earlycheckin | hotel_area_code | hotel_city_code | has_request | distance_booking_checkin | amount_guests | amount_nights | price_per_guest_per_night | costumer_guest_same_nation | pay_now | is_cancel | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 7861445258918608962 | 294 | 212 | 213 | 88838 | 5.0 | 2012-10-04 10:03:00 | 4.0 | 16.0 | China | 0 | China | 12 | 0 | 0 | 2 | 31.0 | 37.0 | 436.52 | Alipay | Credit Card | CNY | True | 1 | False | 1.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 5832 | 461 | 1.0 | 282.190278 | 12 | 1.0 | 36.376667 | False | True | False |
| 1 | -3175925110616170919 | 222 | 222 | 223 | 51920 | 57.0 | 2012-10-01 10:03:00 | 3.0 | 10.0 | Japan | 0 | Japan | 1 | 0 | 0 | 1 | 70.0 | 26.0 | 54.01 | American Express | Credit Card | JPY | True | 2 | False | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 643 | 2249 | 0.0 | -0.652778 | 1 | 1.0 | 54.010000 | False | True | False |
| 2 | -5166200042028380517 | 257 | 257 | 258 | 90189 | 114.0 | 2014-06-12 08:05:00 | 4.0 | 10.0 | Taiwan | 0 | Taiwan | 2 | 0 | 0 | 1 | 130.0 | 43.0 | 99.18 | Visa | Credit Card | TWD | True | 1 | False | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2900 | 892 | 0.0 | -0.913889 | 2 | 1.0 | 49.590000 | False | True | False |
| 3 | 6165211278500849566 | 256 | 256 | 257 | 236389 | 113.0 | 2010-08-31 07:16:00 | 0.0 | 5.0 | Turkey | 0 | Turkey | 1 | 0 | 0 | 1 | 129.0 | 46.0 | 19.36 | MasterCard | Credit Card | TRY | False | 0 | False | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 0.0 | 0.0 | 3110 | 744 | 1.0 | -0.565278 | 1 | 1.0 | 19.360000 | False | True | False |
| 4 | -1853092131420973567 | 32 | 243 | 245 | 187085 | 57.0 | 2010-07-01 07:38:00 | 3.5 | 10.0 | South Korea | 0 | South Korea | 1 | 0 | 0 | 1 | 74.0 | 27.0 | 175.52 | Visa | Credit Card | KRW | True | 2 | False | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 3760 | 2260 | 0.0 | 210.136111 | 1 | 2.0 | 87.760000 | False | False | True |
| 5 | 8478973924173415354 | 172 | 196 | 198 | 788472 | 109.0 | 2015-01-15 15:54:00 | 3.0 | 10.0 | South Korea | 0 | South Korea | 2 | 0 | 0 | 1 | 74.0 | 27.0 | 68.38 | UnionPay - Creditcard | Credit Card | KRW | False | 0 | False | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1709 | 1636 | 0.0 | 23.031944 | 2 | 2.0 | 17.095000 | False | True | False |
| 6 | -1853437799368162580 | 208 | 231 | 233 | 1634464 | 109.0 | 2016-12-19 12:24:00 | 3.5 | 10.0 | South Korea | 0 | South Korea | 1 | 0 | 0 | 1 | 74.0 | 8.0 | 163.60 | Visa | Credit Card | KRW | True | 1 | False | 1.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1.0 | 2964 | 2477 | 2.0 | 22.692361 | 1 | 2.0 | 81.800000 | False | False | True |
| 7 | 259359728717957150 | 205 | 222 | 225 | 3002333 | 109.0 | 2017-11-11 20:57:00 | 2.0 | 10.0 | Thailand | 0 | Thailand | 2 | 0 | 0 | 1 | 125.0 | 45.0 | 48.54 | Visa | Credit Card | THB | False | 1 | False | 1.0 | 0.0 | 0.0 | 1.0 | 0.0 | 0.0 | 0.0 | 2964 | 2477 | 2.0 | 16.167361 | 2 | 3.0 | 8.090000 | False | False | False |
| 8 | -1624588124260700023 | 237 | 258 | 260 | 1160850 | 61.0 | 2016-01-27 12:39:00 | 3.0 | 10.0 | South Korea | 0 | South Korea | 3 | 0 | 0 | 1 | 74.0 | 27.0 | 119.11 | UnionPay - Creditcard | Credit Card | KRW | False | 2 | True | 1.0 | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 0.0 | 3901 | 2459 | 2.0 | 20.722917 | 3 | 2.0 | 19.851667 | False | True | True |
| 9 | 8703485699898329335 | 113 | 230 | 231 | 304893 | 38.0 | 2010-11-17 07:09:00 | 3.5 | 10.0 | China | 0 | China | 2 | 0 | 0 | 1 | 31.0 | 37.0 | 87.78 | UNKNOWN | Invoice | CNY | False | 2 | True | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 4806 | 2745 | 0.0 | 116.028472 | 2 | 1.0 | 43.890000 | False | True | False |
| h_booking_id | booking_datetime | checkin_date | checkout_date | hotel_id | hotel_country_code | hotel_live_date | hotel_star_rating | accommadation_type_name | customer_nationality | guest_is_not_the_customer | guest_nationality_country_name | no_of_adults | no_of_children | no_of_extra_bed | no_of_room | origin_country_code | language | original_selling_amount | original_payment_method | original_payment_type | original_payment_currency | is_user_logged_in | cancellation_policy_code | is_first_booking | request_nonesmoke | request_latecheckin | request_highfloor | request_largebed | request_twinbeds | request_airport | request_earlycheckin | hotel_area_code | hotel_city_code | has_request | distance_booking_checkin | amount_guests | amount_nights | price_per_guest_per_night | costumer_guest_same_nation | pay_now | is_cancel | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 46917 | -3955370707847627756 | 147 | 186 | 189 | 289317 | 45.0 | 2011-10-26 16:50:00 | 1.0 | 9.0 | China | 0 | China | 2 | 0 | 0 | 1 | 31.0 | 37.0 | 116.77 | Credit Card | CNY | True | 0 | False | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 5262 | 142 | 0.0 | 38.468056 | 2 | 3.0 | 19.461667 | False | True | False | |
| 46918 | -7280254002553494006 | 80 | 270 | 271 | 196931 | 57.0 | 2011-06-29 10:05:00 | 4.0 | 10.0 | South Korea | 0 | South Korea | 1 | 0 | 0 | 1 | 74.0 | 27.0 | 196.43 | MasterCard | Credit Card | KRW | True | 2 | False | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2722 | 1335 | 0.0 | 189.234028 | 1 | 1.0 | 196.430000 | False | False | True |
| 46919 | 8038861849194051967 | 32 | 243 | 245 | 812762 | 57.0 | 2015-03-11 14:43:00 | 3.0 | 10.0 | South Korea | 0 | South Korea | 1 | 0 | 0 | 1 | 74.0 | 27.0 | 132.78 | Visa | Credit Card | KRW | False | 2 | True | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 3760 | 2260 | 0.0 | 210.143056 | 1 | 2.0 | 66.390000 | False | False | True |
| 46920 | -5687848489097746853 | 180 | 215 | 218 | 868632 | 57.0 | 2015-02-26 16:35:00 | 1.0 | 9.0 | South Korea | 0 | South Korea | 1 | 0 | 0 | 1 | 74.0 | 27.0 | 87.01 | Visa | Credit Card | KRW | True | 2 | False | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 3950 | 220 | 0.0 | 34.154861 | 1 | 3.0 | 29.003333 | False | True | True |
| 46921 | 4805148141901219862 | 173 | 245 | 247 | 3132844 | 61.0 | 2017-11-06 16:47:00 | 3.0 | 10.0 | Taiwan | 0 | Taiwan | 3 | 0 | 0 | 1 | 130.0 | 43.0 | 183.54 | Visa | Credit Card | TWD | True | 2 | False | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 5242 | 731 | 0.0 | 71.735417 | 3 | 2.0 | 30.590000 | False | True | False |
| 46922 | 7859361556233200164 | 258 | 259 | 260 | 2504240 | 57.0 | 2017-07-08 14:23:00 | 3.0 | 18.0 | Japan | 0 | Japan | 2 | 0 | 0 | 1 | 70.0 | 26.0 | 142.68 | UNKNOWN | Credit Card | JPY | False | 2 | True | 1.0 | 0.0 | 0.0 | 1.0 | 0.0 | 0.0 | 0.0 | 185 | 2039 | 2.0 | 0.063194 | 2 | 1.0 | 71.340000 | False | True | False |
| 46923 | 2778941468684758600 | 265 | 270 | 272 | 2613173 | 57.0 | 2017-08-15 07:07:00 | 2.0 | 5.0 | South Korea | 0 | South Korea | 1 | 0 | 0 | 1 | 74.0 | 27.0 | 49.74 | MasterCard | Credit Card | KRW | True | 1 | False | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 4463 | 2567 | 0.0 | 4.054167 | 1 | 2.0 | 24.870000 | False | True | True |
| 46924 | -8952794303652718161 | 95 | 203 | 205 | 276008 | 61.0 | 2014-06-19 08:05:00 | 3.5 | 10.0 | Taiwan | 0 | Taiwan | 3 | 0 | 0 | 1 | 130.0 | 43.0 | 140.12 | Visa | Credit Card | TWD | True | 2 | False | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1240 | 731 | 0.0 | 107.054861 | 3 | 2.0 | 23.353333 | False | False | True |
| 46925 | -4286304901316077629 | 212 | 213 | 215 | 1573295 | 114.0 | 2016-10-04 13:32:00 | 3.0 | 10.0 | Taiwan | 1 | Taiwan | 2 | 0 | 0 | 1 | 130.0 | 43.0 | 87.30 | MasterCard | Credit Card | TWD | True | 2 | False | 1.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 5208 | 2004 | 1.0 | 0.458333 | 2 | 2.0 | 21.825000 | False | True | False |
| 46926 | 8516014471330804625 | 207 | 241 | 242 | 91737 | 52.0 | 2009-06-28 02:02:00 | 3.5 | 10.0 | Bangladesh | 1 | Bangladesh | 2 | 0 | 0 | 1 | 12.0 | 8.0 | 58.01 | MasterCard | Credit Card | USD | True | 2 | False | 0.0 | 0.0 | 0.0 | 1.0 | 0.0 | 0.0 | 0.0 | 2597 | 2302 | 1.0 | 33.340278 | 2 | 1.0 | 29.005000 | False | False | False |